If you have the person’s birthday in one cell in mm/dd/yyyy format, you can use the following formula to calculate their age: =DATEDIF(birthday,TODAY(),”y”) & ” years old” There are a few different ways that you can calculate age in Excel, depending on the format of your data. How do you calculate date of birth in Excel? How do I calculate age in mm/dd/yyyy in Excel? For example, if your ages are in column A and your current date is in cell B1, you could use the following array formula: =B1-(ROW(A1:A100)/100)*365 This would give you an array ofbirth dates corresponding to each age in column A (assuming that all of these people were born on January 1st). Another way is to use an array formula with one of these functions. One way is to create a column next to your ages and then use either of the above formulas for each row. If you have a list of ages and need to calculate the corresponding birth dates en masse, there are a few different ways that you can do this as well. For example, if someone is 10 years and 3 months old today, you could use the following formula: =DATEDIF(TODAY()-3/12,10,”y”) This would give you their birth date (assuming they were born on April 1st). You could also use a combination of these two functions to get more accurate results. So, if someone is 10 years old today, you would use the following formula: =YEARFRAC(TODAY(),10) This would give you their birth date (again assuming they were born on January 1st). This function gives you the fraction of a year between two dates. For example, if someone is 25 years old today, you would use the following formula: =DATEDIF(TODAY(),25,”y”) This would give you the person’s birth date (assuming they were born on January 1st).Īnother way to calculate someone’s birth date from their age is to use the YEARFRAC function. To use this function, you would need to know the person’s age and the current date. This function calculates the number of days, months, or years between two dates. There are a few different ways that you can calculate someone’s birth date from their age in Excel.
0 Comments
Leave a Reply. |