Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DATE FORMULA
I TRYING TO FIND A FORMULA I CAN USE TO FIND THE NUMBER OF MONTHS BETWEEN
TODAYS DATE AND A PREVIOUS DATE. |
#2
|
|||
|
|||
=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. |
#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. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date formula | Excel Worksheet Functions | |||
addition to my date formula...required | Excel Worksheet Functions | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Formula with date constraints | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |