Anniversary...date calculations

K

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??
 
B

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
 
Top