Floored by Date Subtraction !!

[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!!

 

[Andy B]

Hi

Try Chip's site:
http://www.cpearson.com/excel/datearith.htm

Andy

 

[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")