| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
input 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. -- Doug P |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
input a date or update it based on date in another cell
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. "Doug P" wrote in message ... -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. -- Doug P |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data input based on date list? | Excel Worksheet Functions | |||
| Recording Time & Date based on data input | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
