Conditional Formatting to highlight 'between months'

[shauneyd]

Hi Guys,

I hope I am not over-thinking this one but I am trying to work out (if possible) conditional formatting for the following:

I have a list of set dates in column H starting with H2 and the date is formatted as 06/03/2017.

I would like conditional formatting to highlight cells in this range that are 'between 3 and 4 months old'.

Can this be done? I have been playing around with EDATE function like so:

Greater than =EDATE(TODAY(),-3) (This highlights cells less than 3 months ago for me)

and

Less than =EDATE(TODAY(),-4) (This highlights cells more than 4 months ago for me)

But, as far as getting a function to highlight 'between 3 and 4 months' I cannot seem to get it.

Many thanks for any suggestions in advance guys!

[Special-K]

Try this

Select A1 where it is one of your dates

Conditional Formatting
New Rule
Use a formula to determine...

=AND(A1<=EDATE(TODAY(),-3),A1>=EDATE(TODAY(),-4))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

[shauneyd]

Try this

Select A1 where it is one of your dates

Conditional Formatting
New Rule
Use a formula to determine...

=AND(A1<=EDATE(TODAY(),-3),A1>=EDATE(TODAY(),-4))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

Perfect Special-K,

Thank you so much for taking the time to reply - I really appreciate it.

Regards,

Shauneyd

[Special-K]

I would test thoroughly with consecutive dates just to make sure this does work.
I only tested with monthly differences, ie 06/03/2017, 06/02/2017, 06/01/2017.