Find the Current Date

Use TODAY and NOW for dates that update automatically.

You will learn to

• Insert a live current date
• Calculate days relative to today

How it works

TODAY() returns the current date and updates whenever the workbook recalculates. NOW() includes the time. To insert a static date instead, press Ctrl+; in Excel.

=TODAY()