That will normally work, but note that DATEDIF assumes a month is as
long as the starting month (first argument), so if
A1: 31 January 2005
A2: 1 March 2005
A3: =DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months " &
DATEDIF(A1,B1,"Md")&" Days"
will return
0 Years 1 Months -2 Days
There really isn't any consistent workaround, since "month" is not an
exact unit.
In article ,
"PC" wrote:
Possibly this will work
=DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months
"&DATEDIF(A1,B1,"Md")&" Days"
Startdate is in A1, Enddate is in B1
|