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