Need a formula that highlights a cell if it is within the next 7 days (but not today)
Hi there,
I need a formula for my worksheet that will highlight certain cells if TODAY() occurs in the next 7 days. The catch is that I also do not want it to highlight if it IS TODAY().
The formula I've been trying is:
AND(A1<(TODAY()+7), A1>TODAY()
But this formula does not work. Any help is greatly appreciated!
How about this?
=AND(A1<(TODAY()+7), A1>=TODAY()+1)
Last edited by AliGW; 02-20-2020 at 09:06 AM. Reason: Typo corrected.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
=AND(A1<(TODAY()+7), A1>TODAY()) should do the trick
If not post a sample sheet explaining what does not work and expected resuls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks