| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date formulas needed
Three cells involved:
E4: date entered manually by user F4: date next IPP due G4: date next Review due Need formulas for F4 and G4 to satisfy these conditions: 1) E4 is empty: F4, G4 = "" 2) E4 <= 21 days from today: F4 = E4 + 21 days, G4 = E4 + 90 days 3) Else: F4 = E4 + 6 months, G4 = E4 + 1 year -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas needed for Calendar? | New Users to Excel | |||
| how do i set up a formulas with an if date? | Excel Worksheet Functions | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Threaded Mode
