What would the formula be to calculate the number of months between 2 dates? Thanks Louis
L Louis Nov 27, 2003 #1 What would the formula be to calculate the number of months between 2 dates? Thanks Louis
V Vasant Nanavati Nov 27, 2003 #2 The usually-undocumented function =DATEDIF(date1,date2,"m") will return the difference in months.
K Kevin Stecyk Nov 27, 2003 #3 Louis, Please consult Chip Pearson's site here.... http://www.cpearson.com/excel/datedif.htm Chip provides an excellent explanation of the DATEDIF function. DATEDIF is available to all XL versions, but is only shown, I believe, in XL 2000 help file. Regards, Kevin
Louis, Please consult Chip Pearson's site here.... http://www.cpearson.com/excel/datedif.htm Chip provides an excellent explanation of the DATEDIF function. DATEDIF is available to all XL versions, but is only shown, I believe, in XL 2000 help file. Regards, Kevin
