Floored by Date Subtraction !!

U

UtpalAsh

I have two columns with dates in dd/mm/yyyy format. I want to subtract
one date from the other and get the result in years, months and days,
in the next three columns. Please help!!
 
N

Nicky

There are special date difference functions in excl that do this.

Assuming your first date pair is in cells A1 and A22 try these
formulas:

for the year, in cell C1:
=DATEDIF(A1,B1,"Y")

for the month, in cell D1:
=DATEDIF(A1,B1,"YM")

for the day, in cell E1:
=DATEDIF(A1,B1,"MD")
 
Top