Anniversary...date calculations

[Kristin]

I want to work out the number of years, months and days
from a given date to the current date. E.G. how many
YY,MM,DD is it from 29.07.1996 to the current date?

Can anyone help me in writing the formula??

 

[beeawwb]

About to leave work, so I'll just quickly paste the formula, from Exce
Function Dictionary. (Sorry, can't find the exact link)


="Difference Is"&DATEDIF(C8,TODAY(),"y")&" Years
"&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&
Days"

Replace C8 with your first date, and Today with your second date (o
cell, etc)

Hope it helps

-Bo

 

[Frank Kabel]

Hi Kristin
have a look at
http://www.cpearson.com/excel/datedif.htm#Age

HTH
Frank

 

[Kristin]

Thanks Bob, - worked like a charm!!!