Subtract from today's date

[57Caddy]

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

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[57Caddy]

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?

 

[Conan Kelly]

57Caddy,

Did you Try:

=Today()-F11

That seems to be what you are describing.

HTH,

Conan

 

[Peo Sjoblom]

=DATEDIF(TODAY(),G11,"m")

you need to put quotes around the m

--


Regards,


Peo Sjoblom

 

[Conan Kelly]

ooopppssss!!!

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

 

[David Biddulph]

=DATEDIF(F11, TODAY(), "m")
--
David Biddulph

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?

 

[57Caddy]

Ah, that did the trick. Thanks!

=DATEDIF(TODAY(),G11,"m")

you need to put quotes around the m

--


Regards,


Peo Sjoblom