Return total number of YEARS & MONTHS in a cell
Hi,
Try something like this:
=DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months"
Regards!
Jean-Guy
"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
|