| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the IF formula to flag dates 21 days prior to deadlin
I am trying to set up a spreadsheet that will flag me 21 days from the date I
send out documents. So that I can follow up on those documents. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use the IF formula to flag dates 21 days prior to deadlin
What do you have so far? You could do this with conditional formatting or
something like this to define the date 21 days (calendar) out =date(year(A1),month(A1),day(A1))+21 Or a combination of the two "Wanderer" wrote: I am trying to set up a spreadsheet that will flag me 21 days from the date I send out documents. So that I can follow up on those documents. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| duration days | Excel Discussion (Misc queries) | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Linear Mode
