View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Date calculation

Yes, here's one. With the earlier date in A1 and the later date in B1, try:-

=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & " Months, " &
DATEDIF(A1,A2,"md") & " Days"

Mike

"KarenM" wrote:

Hi,

I am trying to arrive at a date difference between 2 cells that will display
like 9 years, 10 months, 25 days. Does anyone have a suggestion?

Thanks