DATE FORMULA
 

I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN
TODAYS DATE AND A PREVIOUS DATE.

=DATEDIF(A20,TODAY(),"M")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MARIA" wrote in message
...
I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN
TODAYS DATE AND A PREVIOUS DATE.

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.

In article ,
"MARIA" wrote:

I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN
TODAYS DATE AND A PREVIOUS DATE.