| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract from today's date
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
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 | | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
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 | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
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 | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
=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 | | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
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 | | |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
=DATEDIF(F11, TODAY(), "m")
-- David Biddulph "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 | | |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract from today's date
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 | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| How do I subtract today's date from one before 1900? | Excel Discussion (Misc queries) | |||
Linear Mode
