| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I track next due date
Hi,
I conduct audits annually and want to highlight upcoming audit dates that I need to begin working on scheduling. I am working with the last audit date and need 4 months notice. I have tried to setup conditional formatting but get everything but what I want. Column E lists the last audit date: 8/10/11 (needs to highlight) 5/26/11 (needs to highlight) 4/6/12 11/2/11 Can anyone help?? Thanks! Laurie Last edited by LMDeWitt : May 22nd 12 at 04:46 PM Reason: change title |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with dates in the past | Excel Programming | |||
| record values from past dates | Excel Discussion (Misc queries) | |||
| Past Due - Due Dates | Excel Worksheet Functions | |||
| Highlight past & future events | Excel Discussion (Misc queries) | |||
| HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE | Excel Programming | |||
Threaded Mode
