Hi all, looking for some help with creating a conditional formatting formula for dates between 30-60 months, basically for anything 2 months from today's date.
I've googled and came up with this =AND($H2-TODAY()>=30, $H2-TODAY()<=60) but I can't get it to work as a conditional formatting rule. I've changed the cells' formatting to reflect the colors I want, so it's not like I'm forgetting that piece.
This is what I'm trying to do. In the image below, I want the dates in October to be highlighted. And then when it's September, I want the months in November to be highlight, etc. Any help would be greatly appreciated!
dates.png
Bookmarks