Cellgrids Cellgrids
Home › Excel formulas › Date and Time › DATEDIF + TODAY

DATEDIF + TODAY Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

DATEDIF + TODAY is an Excel Date & Time function. Finds how many days have passed between a fixed start date and today, updating automatically every day.

DATEDIF + TODAY syntax

=DATEDIF(start_date, TODAY(), "d")

Arguments

When to use DATEDIF + TODAY

Showing a live 'days since launch' counter that updates on its own.

Practice DATEDIF + TODAY online, free

Open the live Excel-style spreadsheet and try DATEDIF + TODAY yourself. No Excel install or sign-up needed to start.

Practice DATEDIF + TODAY now →

More Date & Time functions

Frequently asked questions

What does the DATEDIF + TODAY function do in Excel?

Finds how many days have passed between a fixed start date and today, updating automatically every day.

What is the syntax of DATEDIF + TODAY in Excel?

The syntax is =DATEDIF(start_date, TODAY(), "d"). start_date: The starting date.

Where can I practice DATEDIF + TODAY online for free?

Open the free live spreadsheet on Cellgrids and try DATEDIF + TODAY yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts