| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use Text to wipe out subsequent dates?
Hi.
I have a project tracking spreadsheet that I need help with. In F2 the project leader enters a start date, In G2 a formula computes a Estimated Finish Date based on F2 input, in G2 the project leader enters an Actual Finish Date.....other Estimated Finish Dates are computed on down the line based on F2. What I need is a way to allow the project manager to enter text in the G2 cell and if they enter text then all the subsequent cells turn blank. The way it is right now they can enter text (like "inactive") and all the subsequent dates remain. Ideas? Thanks Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How i have #10 in cell when previous#5 and subsequent #15 | New Users to Excel | |||
| Format text 'dates' to real dates | Excel Worksheet Functions | |||
| Elimnating subsequent cells | Excel Discussion (Misc queries) | |||
| Search for a character subsequent to its first appearance | Excel Worksheet Functions | |||
| Can I have info on first tab transferred to subsequent tabs? | Excel Worksheet Functions | |||
Threaded Mode
