Q How do you calculate the period between two dates, with
the answer shown as years and days, for example, 5 years + 60 days? I’ve looked
at Excel’s DATEDIF function but it doesn’t seem to offer the solution I need.
Peter Tucker
A It will if you use the DATEDIF (date difference) function in a formula like this:=DATEDIF(A1,B1,”y”)&” years + 4“& DATEDIF(A1,B1,”yd”)&” days”Enter your earlier date in cell A1 and the later date in B1.
Do you agree?
Have your say on this article