Conditional formatting date older than

[nickpavlov]

I am using the formula below in conditional formatting for a date that is 18 months or older.

How can I change it to be 18 months and 1 day or older?

=AND(A4<>"",G4 < EDATE(TODAY(),-18))

Thanks for any help.

Nick

[AliGW]

Like this:

=AND(A4<>"",G4 < EDATE(TODAY(),-18)-1)

If this isn’t what you want, try plus one at the end.

[nickpavlov]

Thanks, that worked. I wasn't sure if that would add a day or a month, but it worked great!