Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I show dates older than present date?
I have created a spreadsheet that shows dates of WORKDAYS a certain number
past the "start date". I would like to know if there is a way to have the date automatically change to "red" once the current date surpasses the workday listed in the cell. For example: I have a start date of 6/20/05 and the WORKDAY function shows that in 5 days it will be 6/27/05 and in 25 days it will be 8/2/05. Let's say that today is 6/29/05...how do I get the cell that shows 6/27/05 to automatically turn red (so as to show that it is delinquent)? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Using a col of Dates by day I want to determine a wk ending date. | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |