View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default 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