Highlighting future dates [Closed]

Hoffy 3 Posts Wednesday July 11, 2018Registration date July 20, 2018 Last seen - Jul 11, 2018 at 12:00 PM - Latest reply: Ambucias 55550 Posts Monday February 1, 2010Registration dateModeratorStatus October 17, 2018 Last seen
- Jul 11, 2018 at 04:52 PM
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 

1 reply

Ambucias 55550 Posts Monday February 1, 2010Registration dateModeratorStatus October 17, 2018 Last seen - Jul 11, 2018 at 04:52 PM
0
Thank you
Greetings,

Please, bare in mind that CCM.net is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator