Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Answer 1 / 3
Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
 457
Hi Hoffy,

Could you give an example where the formula fails? It's working fine for me.


Best regards,
Trowa
Answer 2 / 3

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

For dates between 30 and 60 days try:

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

Hope this helps.
Answer 3 / 3

Thank you - that works brilliantly :)
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!