| 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 |
| 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 | |||
Threaded Mode
