 |
 | 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 / New Users / July 2007input a date or update it based on date in another cell
-Someone asked me to setup a spreadsheet like this cell b2 is entered as a date cell c2 is entered as a number cell d2 is a calculated date =b2+c2 now cell c2 gets more interesting. the user will enter a date like they did in b2, but if the number in c2 is changed modifing the date in d2 they want the date in c3 to be advanced as well. They want to use it to track some projects using software they have already paid for and not buy additional software.  SignatureDoug P You don't explain how the date in c3 is affected by the change in c2. If c2 changes from 2 to 5 do you want cell c3 to be incremented by 5? or do you want it incremented by 5-2 = 3? Give us some before and after examples. > -Someone asked me to setup a spreadsheet like this > [quoted text clipped - 10 lines] > already > paid for and not buy additional software.
|
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.