D
Deborah
I used the following formula to calculate the difference between two dates:
=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"
01/01/2006 28/02/2006 0 years, 1 months, 27 days
01/01/2006 31/01/2006 0 years, 0 months, 30 days
Which is ok but I would want the result for the first example to be 2 months
and for the second example 1 month.
Should I use another formula?
Thanks in advance
Deborah
=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"
01/01/2006 28/02/2006 0 years, 1 months, 27 days
01/01/2006 31/01/2006 0 years, 0 months, 30 days
Which is ok but I would want the result for the first example to be 2 months
and for the second example 1 month.
Should I use another formula?
Thanks in advance
Deborah