Ah, that did the trick. Thanks!
"Peo Sjoblom" wrote:
=DATEDIF(TODAY(),G11,"m")
you need to put quotes around the m
--
Regards,
Peo Sjoblom
"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
|
|