Date Calculation Problem

[andyp161]

Hi there,

I would like to find out the difference in years/months/days betwee
two dates e.g. if I have 01/01/04 in A1 and 10/01/04 in B2, is there
function that I can use to calculate the period between the two date
in C2 i.e. 9 days???

Many thanks

And

 

[Dave Peterson]

If you just want difference in days, just subtract the two and format as
General.

If you want 12 years, 3 months, 28 days, then take a look at Chip Pearson's
explanation of =datedif() at:
http://www.cpearson.com/excel/datedif.htm