 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / November 2007Subtract 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 Look here: http://www.cpearson.com/excel/datedif.aspx  SignatureKind 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 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? > Look here: > [quoted text clipped - 5 lines] > | > | Thank you 57Caddy, Did you Try: =Today()-F11 That seems to be what you are describing. HTH, Conan > That seems to work if I create a new field for todays date such as cell > G11 [quoted text clipped - 13 lines] >> | >> | Thank you ooopppssss!!! Didn't read your orig post close enough. Please ignore my response. > 57Caddy, > [quoted text clipped - 25 lines] >>> | >>> | Thank you =DATEDIF(TODAY(),G11,"m") you need to put quotes around the m SignatureRegards, Peo Sjoblom > That seems to work if I create a new field for todays date such as cell > G11 [quoted text clipped - 13 lines] >> | >> | Thank you Ah, that did the trick. Thanks! > =DATEDIF(TODAY(),G11,"m") > [quoted text clipped - 17 lines] > >> | > >> | Thank you =DATEDIF(F11, TODAY(), "m") SignatureDavid Biddulph > That seems to work if I create a new field for todays date such as cell > G11 [quoted text clipped - 13 lines] >> | >> | Thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.