| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the IF formula to flag me 21 days after the date?
I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use the IF formula to flag me 21 days after the date?
Wanderer --
Howze about: A 1 Date 2 =IF(TODAY()-A121,"Holy cow!","") Should do the trick. HTH "Wanderer" wrote: I need to set up a spreadsheet that will flag me when it is 21 days past the date I input originally. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Help with Date Formula | Excel Worksheet Functions | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| formula for tracking number of elapsed days from a stard date | Excel Worksheet Functions | |||
Linear Mode
