Previous Topic Next Topic

Highlighting future dates

Solved/Closed
Hoffy Posts 2 Registration date Wednesday July 11, 2018 Status Member Last seen July 20, 2018 - Jul 12, 2018 at 03:36 AM
 Hoffy - Jul 13, 2018 at 03:33 AM
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 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 12, 2018 at 11:35 AM
Hi Hoffy,

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


Best regards,
Trowa
0
Answer 2 / 3
Hoffy
Jul 12, 2018 at 11:47 AM
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.
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Jul 12, 2018 at 12:11 PM
Hi Hoffy,

For dates between 30 and 60 days try:

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

Hope this helps.
0
Answer 3 / 3
Hoffy
Jul 13, 2018 at 03:33 AM
Thank you - that works brilliantly :)
0

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
If a cell contains any text then add a value (with dates)
ryannordgren -
ryannordgren -

7 responses