Conditional Date Formating

I would like a dated cell to highlight if it is three months ahead of today. The standard options deal with Today Tomorrow Next week etc but I need a longer time scale. Can this be done by applying some formula or similar.

Hi,

Assuming your date is in A1 use conditional formatting to apply the highlight you want. Select the formula option and try:

=A1=EDATE(TODAY(),3)

HTH

Steve

Use =MONTH(A1-TODAY())>=4 for your formula in CF.

EDIT: Assuming you mean three months or further out? Otherwise (for exactly three months), use SteveG's suggestion.

Date higlight issue.xlsx

I hope the attached solution works for you. It under conditional formating

Many Thanks