Dashboards & Reporting: Deadline Countdown Label

Excel Formulas › Dashboards & Reporting

A tracker reads better with words than with a number. Subtracting the as-of date from the due date gives the days left, and a nested IF turns the sign into Overdue, Due today or Due in N days.

Functions used (tap for the full reference guide):

The example

Three worked examples. Change any yellow input in the practice workbook and the results recalculate.

The formula

Here is the formula, built directly from the inputs:

How it works

Here is the logic, one piece at a time:

1. B2-C2 is days remaining.
2. D2<0 means overdue.
3. D2=0 means due today.
4. & joins text and the number.

Keep every number in its own input cell so the formula never needs editing.

Try it: interactive demo

Variations

Use TODAY

Live countdown.

Singular day

Handle 1 day.

Pitfalls & errors

Practice workbook

Frequently asked questions

Related formulas: Dynamic Dashboard with a Dropdown · KPI vs Target Status Indicator · RAG (Red/Amber/Green) Status

Function references: IF