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
========
