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)


"MARIA" <[email protected]> wrote in message
news:[email protected]...
> I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN
> TODAYS DATE AND A PREVIOUS DATE.

[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.

In article <[email protected]>,
"MARIA" <[email protected]> wrote:

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