TODAY Function In Excel
Associated Files Download Links
In this Article
This tutorial demonstrates how to use the Excel TODAY Function in Excel to get the current date.
TODAY Function Overview
The TODAY Function Returns the current date.
To use the TODAY Excel Worksheet Function, Select cell and Type:
(Notice how the formula input appear)
TODAY Function syntax and Inputs:
|
1 |
=TODAY() |
Insert Today’s Date
The TODAY Function insert’s today’s date:
|
1 |
=TODAY() |
This is different than the NOW Function which will insert today’s date and time:
|
1 |
=NOW() |
You can learn how to format Today’s date by reading our Format Dates article.
By adding 1 to the TODAY Function you can get tomorrow’s date:
|
1 |
=TODAY()+1 |
Or by using the EDATE Function you can jump months ahead or backwards:
|
1 |
=EDATE(B3,C3) |
Today’s Day Number
Use the DAY Function to get today’s day number:
|
1 |
=DAY(TODAY()) |
Today’s Month
Or use the MONTH Function to get today’s month:
|
1 |
=MONTH(TODAY()) |
(Click the MONTH Function link to learn about how to display the month name instead of number)
Today’s Year
Or use the YEAR Function for today’s year:
|
1 |
=YEAR(TODAY()) |
Today’s Weekday Number
You can also use the WEEKDAY Function to calculate Today’s day of the week (1-7):
|
1 |
=WEEKDAY(TODAY(),1) |
(Click the WEEKDAY Function link to learn about how to convert the weekday number to the weekday name)
Today’s Week Number
Or the WEEKNUM Function to calculate today’s week number of the year:
|
1 |
=WEEKNUM(TODAY(),1) |
TODAY in Google Sheets
The TODAY Function works exactly the same in Google Sheets as in Excel:
