DATE FORMULA

[MARIA]

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

 

[Bob Phillips]

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

--

HTH

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

 

[JE McGimpsey]

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.