I'm using Excel 07; I need to set conditional format based on dates. Row "C"
projects 4yrs 6months from "B"; I need each row to change colors based on:
"C" is less then today's date ($C2<TODAY()); Today's date is within 6months
of "C"; Today's date is within 90days of "C"; and today's date is within
30days of "C". I would appreicate any help. Thanks

B C
2008 05 06 2012 11 06

For 30 days or 90 days, use ordinary arithmetic; e.g. TODAY()-30.
That's because dates in Excel are a count of days since a fixed
starting point.

For reckoning months, look in Excel's built-in Help for the EDATE()
function.

This will work....I can use TODAY()-120. Thanks!

"zvkmpw" wrote:

For 30 days or 90 days, use ordinary arithmetic; e.g. TODAY()-30.
That's because dates in Excel are a count of days since a fixed
starting point.

For reckoning months, look in Excel's built-in Help for the EDATE()
function.
.