Forum Discussion

Copper Contributor

Apr 03, 2025

Expiry date help.

Hi, i am looking for a formula to turn a cell different colours as a test expiry date approaches. I have column D with the date the test was taken. I then have column E with the formula =IF(D3=""...

Formulas and Functions

office 365

HansVogelaar

MVP

Apr 03, 2025

Create a conditional formatting rule with formula

=AND($E3<>"", $E3<=EDATE(TODAY(), 3))

or alternatively

=AND($D3<>"", $D3<=EDATE(TODAY(), -3))