MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtracting dates


Posted by Quang Tran on August 23, 2001 2:39 PM

I've done this before, but I can't seem to get it right this time. I would like to subtract 2 dates, such as today's date - birthdate to get the age. Thank you for any assistance.


Posted by Barrie Davidson on August 23, 2001 2:48 PM

Assuming the birthdate is in cell E1 and the second date is in cell E2, the following formula will give you age expressed as years, months, and days.

=IF(MONTH(E2)>=MONTH(E1),YEAR(E2)-YEAR(E1),YEAR(E2)-YEAR(E1)-1)&" years "&IF(MONTH(E2)-MONTH(E1)<0,MONTH(E2)-MONTH(E1)+12,MONTH(E2)-MONTH(E1))&" months "&DAY(E2)-DAY(E1)&" days"

Barrie

Posted by Aladin Akyurek on August 23, 2001 2:52 PM

=YEAR(TODAY())-YEAR(A1)

or

=DATEDIF(A1,TODAY(),"Y")

or, if too picky about it, use

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days"

Aladin

Posted by Quang Tran on August 23, 2001 3:03 PM

Thank you all for helping.