Z zivro Feb 18, 2009 #1 I would like to know how I can subtract 2 dates from each other and as a result get the difference in number of months.
I would like to know how I can subtract 2 dates from each other and as a result get the difference in number of months.
M Mike H Feb 18, 2009 #2 Hi, With the earlier date in a1 =DATEDIF(A1,B1,"m") Datedif isn't documented in excel, for help look here http://www.cpearson.com/excel/datedif.aspx Mike
Hi, With the earlier date in a1 =DATEDIF(A1,B1,"m") Datedif isn't documented in excel, for help look here http://www.cpearson.com/excel/datedif.aspx Mike