G Guest Apr 15, 2005 #1 I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN TODAYS DATE AND A PREVIOUS DATE.
I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN TODAYS DATE AND A PREVIOUS DATE.
B Bob Phillips Apr 15, 2005 #2 =DATEDIF(A20,TODAY(),"M") -- HTH RP (remove nothere from the email address if mailing direct)
J JE McGimpsey Apr 15, 2005 #3 One way: =DATEDIF(<previous date>,TODAY(),"m") See http://cpearson.com/excel/datedif.htm for documentation. And please turn off your CAPS LOCK - all caps is usually considered the equivalent of shouting, and is harder to read.
One way: =DATEDIF(<previous date>,TODAY(),"m") See http://cpearson.com/excel/datedif.htm for documentation. And please turn off your CAPS LOCK - all caps is usually considered the equivalent of shouting, and is harder to read.
