Help with dates
Try this formula...
=IF(TODAY()-H530,1,0)
Rick
"Looping through" wrote in
message ...
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
|