Thread: Help with dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Looping through Looping through is offline
external usenet poster
 
Posts: 69
Default Help with dates

Does anyone out there have a formula that looks at cell (H5) in which it
contains a date (mm/dd/yy) and returns a 1 if the date is older than 30days
from today or 0 is false? Or better yet conditionally format the cell (H5) in
Red if older than 30 days from today.

TIA
Peter