Excel TODAY Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel TODAY Function (Example + Sample File)

What is EXCEL TODAY FUNCTION

The Excel TODAY Function is listed under Microsoft Excel's Date Functions category. It returns the current date and time as per the system’s date and time. The date and time returned by the NOW function update continuously whenever you update anything in the worksheet.

How to use it

To learn how to use the TODAY function in Excel, you need to understand its syntax and arguments:

Syntax

TODAY()

Arguments

  • In TODAY function, there is no argument, all you need to do is enter it in the cell and hit enter, but be careful as TODAY is a volatile function which updates its value every time you update your worksheet calculations.

Notes

Example

To master the TODAY function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used TODAY  with other functions to get the current month number, current year, and current day.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.