 |
 | 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 / Worksheet Functions / May 2006CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY
I need to calculate on a spreadsheet the number of days between a specific date and the date the spread sheet is opened. I need to know the number of days a merchandise has been stored. =TODAY()-A1 where A1 holds that date, and format as general  SignatureHTH Bob Phillips (remove xxx from email address if mailing direct) > I need to calculate on a spreadsheet the number of days between a specific > date and the date the spread sheet is opened. > I need to know the number of days a merchandise has been stored. it did not work. B9 has the date it arrived at whse. I9 is the cell that I need to have the number of days since merchandise arrived. Ex arrived on 05/10/06. the I9 should read "9". With the formula =TODAY()-B9 it reads "01/22/00" > =TODAY()-A1 > [quoted text clipped - 3 lines] > > date and the date the spread sheet is opened. > > I need to know the number of days a merchandise has been stored. Format that cell as general SignatureKevin Vaughn > it did not work. B9 has the date it arrived at whse. I9 is the cell that I > need to have the number of days since merchandise arrived. Ex arrived on [quoted text clipped - 8 lines] > > > date and the date the spread sheet is opened. > > > I need to know the number of days a merchandise has been stored. Sorry, I don't know what I did wrong, it worked. THANKS!!!! > it did not work. B9 has the date it arrived at whse. I9 is the cell that I > need to have the number of days since merchandise arrived. Ex arrived on [quoted text clipped - 8 lines] > > > date and the date the spread sheet is opened. > > > I need to know the number of days a merchandise has been stored. |
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
|
©2009 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.