Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates older than 29 days
I would like a column in my Excel spreadsheet to be made bold once the dates
in that column are more than 29 days old. |
#2
|
|||
|
|||
Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29
-- HTH RP (remove nothere from the email address if mailing direct) "ab" wrote in message ... I would like a column in my Excel spreadsheet to be made bold once the dates in that column are more than 29 days old. |
#3
|
|||
|
|||
One way is to use Format|Conditional formatting.
Cell Value is Less Than =today()-29 (use the dropdowns for the first two and type the last.) And give it a nice old format. ab wrote: I would like a column in my Excel spreadsheet to be made bold once the dates in that column are more than 29 days old. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions |