Highlighting future dates [Closed]

Posts
3
Registration date
Wednesday July 11, 2018
Last seen
July 20, 2018
-
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))

Can anyone help?
See more