Highlighting future dates Solved/Closed

Question

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.

TrowaD · Answer

Hi Hoffy,

Could you give an example where the formula fails? It's working fine for me.

 
Best regards,
Trowa

Hoffy · Answer

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.

Hoffy · Answer

Thank you - that works brilliantly :)

Highlighting future dates

3 responses

Similar discussions

Subscribe To Our Newsletter!