Dates & Deadlines

Overdue flags, days remaining, due dates, and date math.

Subtract the due date from today to see how many days late each item is — clamped to zero so future dates don't go negative.

Mark a task Overdue when its due date has passed and it isn't complete, using IF with AND — the backbone of every tracker.

Subtract today from the due date to count down the days left — clamped to zero so past-due items don't show negative numbers.

Turn each date into a "2026-07" label with TEXT so you can pivot, sort, and subtotal by month — the setup step behind every monthly report.

DATEDIF returns completed years between two dates — the standard way to compute age, tenure, or account lifetime from a start date.