Floored by Date Subtraction !!

  • Thread starter Thread starter UtpalAsh
  • Start date Start date
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!!
 
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")
 
Back
Top