Subtracting Dates

[sam]

Afternoon.

I am trying to subtract dates on an excel worksheet and find the ter
between the two. For example (english date format dd/mm/yy)

01/01/05 - 01/01/04 = 365 days or 1 year

I would ideally like the output to be years then months then days bu
anything would do. Is this possible in excel? If not does anyone kno
of an online calculator that could do this?

Thanks

Sa

 

[Guest]

Hi

The easiest answer is to take one from the other:
=A3-A2
and format the result as General.

Andy.

 

[bj]

there is an undocumented function called datedif() which can be used
see: http://www.cpearson.com/excel/datedif.htm
for a description.

 

[Gary Brown]

There is a function called Datedif. It takes the format as follows:-

DATEDIF(START DATE,END DATE,"[D,M,Y]")

where D is quoted in days, M is quoted in months and Y is quoted i
Year