Return total number of YEARS & MONTHS in a cell
If A1 contains a date then
=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months,
" & DATEDIF(A1,TODAY(),"md") & " days"
for example, in A1:
1/15/1985
the formula returns:
20 years, 11 months, 16 days
--
Gary''s Student - gsnu200757
"Montrose guy" wrote:
Hi guys...
Using Excel 2003 - I found in the help how to return the number of YEARS
between 2 dayes and how many MONTHS.. but not both together...MY goal is the
output to a cell how many Years and Months have passed from TODAY
|