Dates changing colors

J

JAS

I have read the threads concerning the dates, however, I just can't seem to
make it work. I have one column of dates that I want to change when the date
is first 60 and then 30 days out. Can someone help me?
 
M

Max

Something like this will test eg a due date against a defined date range (for
aging purposes). To check A2 (it must contain a real date) whether it is more
than 30 days old but less than or equal to 60 days, use this in your CF,
"Formula is:" :
=AND(TODAY()-A2>30,TODAY()-A2<=60)
Modify to suit your actual criteria
Success? Celebrate it, hit YES below
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using dates for lookup 2
Conditional Formating for dates beyond 30, 60, 90 to be high light 3
changing cell background colors with formulas 5
Excel Average dates help 0
display number if date is in a range 4
Excel Formula - Count Dates from another Sheet 8
Conditional Formatting with Icon Sets 0
conditional formatting expiry dates 1

Top