Dates changing colors

  • Thread starter Thread starter JAS
  • Start date Start date
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?
 
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
 
Back
Top