Date calculation
 

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

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

Date calculation
 

Thanks so much Mike, that's just what I needed. I was kinda on that track,
but it would have taken me much longer. You saved me a lot of time.

Karen


"Mike H" wrote:

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