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
|