Event Countdown and Timeline

Excel Formulas › Events & Catering

All versionsTODAY

Stay on schedule with a live countdown and task due dates. TODAY drives days-until-event, and each task’s due date is the event date minus a lead time — an auto-updating planning timeline.

Quick formula: days until the event:
=event_date - TODAY()
Event date minus today gives days remaining; a task due date is event_date minus its lead-time days.

Functions used (tap for the full reference guide):

TODAYWORKDAY

The example

Days left, auto-updating.

AB
1ItemValue
2Days until event= event − TODAY()
3Send invites (−60d)event − 60

The formula

The formula:

=event_date - TODAY() // event − today

How it works

How it works:

  1. event_date - TODAY() gives days remaining — it recalculates every day.
  2. Each task’s due date = event_date - lead_days (invites −60, final count −14…).
  3. Flag overdue tasks with IF(due_date < TODAY(), "Late", "").
  4. Use WORKDAY if a lead time should count business days only.

One event date drives everything. Put the event date in a single cell and base every task due date on it (event_date - lead_days). Move the date and the whole timeline shifts automatically. Add conditional formatting to shade tasks due within a week, and a static checklist becomes a live project plan.

Try it: interactive demo

Live demo

Event date.

Days until · Send invites by

Variations

Task due date

Lead time before:

=event_date - lead_days

Overdue flag

Past due:

=IF(due_date < TODAY(), "Late", "OK")

Business-day lead

Skip weekends:

=WORKDAY(event_date, -lead_workdays)

Pitfalls & errors

TODAY is volatile. It updates on open — the countdown is always current (and changes daily).

Anchor on one date. Base every task on the single event-date cell so changes cascade.

Weekends. Use WORKDAY if a lead time should ignore weekends.

Practice workbook

📊
Download the free Event Countdown and Timeline practice workbook
An event-countdown sheet with the task-due, overdue, and business-day variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I make an event countdown in Excel?
Use =event_date - TODAY() for days remaining — it auto-updates daily.
How do I set task due dates from the event date?
Subtract a lead time: =event_date - lead_days (e.g. invites at −60 days).
How do I flag overdue tasks?
Use =IF(due_date < TODAY(), "Late", "OK"), often with conditional formatting.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Days until date · Countdown to date/time · Add business days

Function references: TODAYWORKDAY