Highlighting future dates [Solved/Closed]

Report
Posts
3
Registration date
Wednesday July 11, 2018
Status
Member
Last seen
July 20, 2018
-
 Hoffy -
Hi

I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but I am struggling to find a formula to highlight dates that are 30 and 60 days in the future. The idea is to give us 60 and 30 days notice of training required, to enable us to arrange what is necessary.

After several Google searches I came across the following formula, but it only highlighted cells that contained dates with the same month as the selected cell, regardless of the year.

=AND(B4>TODAY(),B4<=(TODAY()+30))

I would be most grateful if any anyone could help me.

Thanking you in advance.

3 replies

Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
440
Hi Hoffy,

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.
Posts
2401
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
543
Hi Hoffy,

For dates between 30 and 60 days try:

=AND(B4>(TODAY()+30),B4<(TODAY()+60))

Hope this helps.
Thank you - that works brilliantly :)