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

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

Help with dates
 

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()-H530

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


"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