View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default Conditional Format Help

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.