# 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

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

3. ## Re: Excel formulas calculation age

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

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

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.

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)

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.

8. ## Re: Excel formulas calculation age

maybe this...

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1