Thread: How do I find the length of time (Years & Months) between 2 dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do I find the length of time (Years & Months) between 2 dates
One way:

A1: <start date
A2: <end date
A3: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & "
months"

See

http://cpearson.com/excel/datedif.htm

for more documentation on DATEDIF().

In article ,
David Picken <David wrote:
Reply With QuoteReply With Quote