On Excel 2016, I have coloumn A, date of birth(dd/mm/yy), and would like to calculate the age as of today. Please advise what is the formula.
Regards,
Asif
On Excel 2016, I have coloumn A, date of birth(dd/mm/yy), and would like to calculate the age as of today. Please advise what is the formula.
Regards,
Asif
Last edited by asifamanulla; 02-09-2020 at 07:33 AM.
It will be this:
=TODAY()-A1
This will give the number of days. If you want it in years and months, have a look at the DATEDIF function: https://exceljet.net/excel-functions...tedif-function
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please see what i got.
The date of birth is 201/10/1986 and after I applied the formula, =TODAY()-A1 the result is 21/04/1933. I am looking for the age and in this case it should be 33 years.
20/10/1986 21/04/1933
Formula:Please Login or Register to view this content.
Thank you Shareez and Ali. Both were correct, just that i had the cell in date format and once i changed the format, it worked.
Fantastic!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks