Log inFree budget
Home / Tricks / Overdue dates turn red by themselves
// trick 039 · Dates

Overdue dates turn red by themselves

The formula to copy, for Excel with Italian function names and for Google Sheets.

The formula

EXCEL (ITALIAN)=E($J2="No";$D2<OGGI())
GOOGLE SHEETS=AND($J2="No";$D2<TODAY())
// this trick is already inside

"Organize 2027" Bundle

All 5 templates in one purchase: save €10.70.

See the template