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

How to change date format to 7 working days a week in ms project 2010? 0
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Conditional formatting dates 3
Using project as a resource tracker 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Auto populate date VBA code 7
Tracked changes by multiple people modified to one 0

Top