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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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