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

 

[Dave Peterson]

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