I need help with a formula to calculate age.
I have separated the dd/mm/yyyy (C1/D1/E1) into 3 different columns.
Is there a way for me to still calculate age?
Thanks
I need help with a formula to calculate age.
I have separated the dd/mm/yyyy (C1/D1/E1) into 3 different columns.
Is there a way for me to still calculate age?
Thanks
try this in F1:
=YEAR(TODAY())-E1
or if you need only compared to 2009. just write: =2009-E1
Is it possible to take the month and date into consideration (within the formula) as well?
If your values in C1:D1 are simply numeric values (not real Excel dates), then
you will need to join the values and use the TEXT function to return a real date.
Adjust this formula for your cell references and date format:
=(TODAY()-TEXT(B1&"/"&A1&"/"&C1,"MM/DD/YYY"))/365
"you will need to join the values and use the TEXT function to return a real date."
can you please explain this further.
I changed the format of the column into text, and tried to put in the formula, but is still only taking into consideration the year solely.
Try this (although i think it's not best solution):
=IF(DATE(YEAR(TODAY());D1;C1)>TODAY();YEAR(TODAY())-E1-1;YEAR(TODAY())-E1)
Also, it's not good to use TODAY() function so many times because it's volatile function and it will slow down your excel workbook.
It's better to put in one cell =TODAY() (e.g. A1) and then refer to that cell:
=IF(DATE(YEAR($A$1;D1;C1)>$A$1;YEAR($A$1)-E1-1;YEAR($A$1)-E1)
You don't need to format the column into text. You only need to join together the values in C1:E1 into a valid text string that Excel can recognize as a date. The TEXT function serves this purpose."you will need to join the values and use the TEXT function to return a real date."
can you please explain this further.
I changed the format of the column into text, and tried to put in the formula, but is still only taking into consideration the year solely.
See attached for example.
maybe this...
=2009-E1-MAX(0;MOD(MONTH(TODAY());D1)-6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks