How can I calculate years and months between 2 dates
F Frank Kabel Apr 15, 2004 #2 Hi have a look at the following site (using DATEDIF) http://www.cpearson.com/excel/datedif.htm
I IainMac Apr 15, 2004 #3 Assuming the 2 dates are incolumns A and B, enter =B1-A1 into C1 and then format, cells, number, custom and type yy:mm
Assuming the 2 dates are incolumns A and B, enter =B1-A1 into C1 and then format, cells, number, custom and type yy:mm
