date calculation

[Muntasar]

I want to calculate one date to another date. Example :
in A1 cell 30.7.2003 and B1 cell 30.5.2001
I want to see in C1 cell .. days-..months- .. years
What foumula I can enter for C1 cell?

Let me know pls.
Thanks
Muntasar

 

[Richard O. Neville]

In C1 enter: =(A1-B1)/365. Format C1 to one or two decimal places. The
result should be 2.17 years, which you can convert into days and months if
you wish.

 

[Dave Peterson]

Take a look at Chip Pearson's notes for =Datedif().
http://www.cpearson.com/excel/datedif.htm