Highlighting future dates
Solved/Closed
Hoffy
Posts
2
Registration date
Wednesday July 11, 2018
Status
Member
Last seen
July 20, 2018
-
Jul 12, 2018 at 03:36 AM
Hoffy - Jul 13, 2018 at 03:33 AM
Hoffy - Jul 13, 2018 at 03:33 AM
Related:
- Highlighting future dates
- Configure word to replace future typed abbreviations - Guide
- How would you change these dates to the dd/mm/yyyy format? - Guide
- Gamescom 2023 dates - Guide
- Defcon 2023 dates - Guide
- Ps4 browsing history dates - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 12, 2018 at 11:35 AM
Jul 12, 2018 at 11:35 AM
Hi Hoffy,
Could you give an example where the formula fails? It's working fine for me.
Best regards,
Trowa
Could you give an example where the formula fails? It's working fine for me.
Best regards,
Trowa
I have tried this formula over and over again. Today I have put it in and it works fine. I must have been doing something wrong.
Thank you so much for your time.
Could I ask another question? If I want to highlight dates between 30-60 days how would I adjust this formula?
Thank you in advance for your advise.
Thank you so much for your time.
Could I ask another question? If I want to highlight dates between 30-60 days how would I adjust this formula?
Thank you in advance for your advise.
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Jul 12, 2018 at 12:11 PM
Jul 12, 2018 at 12:11 PM
Hi Hoffy,
For dates between 30 and 60 days try:
=AND(B4>(TODAY()+30),B4<(TODAY()+60))
Hope this helps.
For dates between 30 and 60 days try:
=AND(B4>(TODAY()+30),B4<(TODAY()+60))
Hope this helps.