Help with dates

[Looping through]

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

 

[Rick Rothstein \(MVP - VB\)]

Try this formula...

=IF(TODAY()-H5>30,1,0)

Rick

 

[Pete_UK]

To apply the conditional formatting, select H5 then click on Format |
Conditional Formatting, then choose Formula Is rather than Cell Value Is in
the first box and put this formula in the next box:

=TODAY()-H5>30

Then click the Format button, select the Patterns tab (for background
colour) and choose red. Click OK twice to exit the dialogue box.

Hope this helps.

Pete