ooopppssss!!!

Didn't read your orig post close enough. Please ignore my response.




"Conan Kelly" wrote in message
...
57Caddy,

Did you Try:

=Today()-F11

That seems to be what you are describing.

HTH,

Conan





"57Caddy" wrote in message
...
That seems to work if I create a new field for todays date such as cell
G11
'=Today()' and then doing =DATEDIF(F11, G11, m).

But is there a way to do so without creating a field for todays date?

"Niek Otten" wrote:

Look he

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"57Caddy" wrote in message
...
|I am sure this is easier than I am making it out but how do I subtract
a date
| in cell F11 from todays date? We want to actually calculate the number
of
| months in between the dates.
|
| Thank you
|
|