# Excel formulas calculation age

1. ## Excel formulas calculation age

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  Register To Reply

2. ## Re: Excel formulas calculation age

try this in F1:

=YEAR(TODAY())-E1

or if you need only compared to 2009. just write: =2009-E1  Register To Reply

3. ## Re: Excel formulas calculation age

Is it possible to take the month and date into consideration (within the formula) as well?  Register To Reply

4. ## Re: Excel formulas calculation age

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.

=(TODAY()-TEXT(B1&"/"&A1&"/"&C1,"MM/DD/YYY"))/365  Register To Reply

5. ## Re: Excel formulas calculation age

"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.  Register To Reply

6. ## Re: Excel formulas calculation age

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)  Register To Reply

7. ## Re: Excel formulas calculation age

"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.
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.

See attached for example.  Register To Reply

8. ## Re: Excel formulas calculation age

maybe this...

=2009-E1-MAX(0;MOD(MONTH(TODAY());D1)-6)  Register To Reply