MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Formula


Posted by liz on December 16, 2001 4:38 AM

I have create a formula that will give me the date difference between the date in B3 and today's date eg =DATEDIF(B3,NOW(),"y". Thats fine. But now I want a formula that will give me how old a person will be in a specific year eg 2003.


Posted by Aladin Akyurek on December 16, 2001 5:46 AM

Liz --

=C3-YEAR(B3)

where C3 houses your target year 2003 and B3 the birth date.

Aladin

========