TODAY Function In Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the TODAY Function in Excel and Google Sheets to get the current date.

TODAY Main Function

Insert Today’s Date

The TODAY Function inserts today’s date:



This is different than the NOW Function which will insert today’s date and time:



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:



Or by using the EDATE Function you can jump months ahead or backwards:



Today’s Day Number

Use the DAY Function to get today’s day number:



Today’s Month

Or use the MONTH Function to get today’s month:



(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:



Today’s Weekday Number

You can also use the WEEKDAY Function to calculate today’s day of the week (1-7):


TODAY weekday

(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:


TODAY week number

TODAY in Google Sheets

The TODAY Function works exactly the same in Google Sheets as in Excel:

TODAY Google sheet

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions