How to use TODAY Function in Excel

how to use excel today function

Quick Intro

By using Excel TODAY Function you can insert the current date in a cell. It will give you the current date which will update every time you recalculate your worksheet.

In the below example, I have deducted 1 day from today’s date to get yesterday’s date.

Definition For Excel TODAY Function



  • It has no arguments. You just have to put blank parentheses.

More Information on Excel TODAY Function

  • It is a volatile function which will recalculate every time a calculation in performed.
  • Today function returns a valid date serial number as per excel’s date system & you can use this date further with other calculations.
  • When you enter today function in a cell where you have “General” number format, excel will convert that format into date format once you enter your formula.
  • To enter a static date in a cell you can use the shortcut key Control + ;.


In the below example, I have used today function with other functions to get current month number, current year & current day.

Use Excel TODAY Function With Other Function

Use Excel TODAY Function With Weekday Function

You can use this function with other function to create some dynamic formulas. The best example is when you need the current date in your formula, you can use today and you don’t have to enter date every time.

A simple use of today is for calculating a person’s age.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel TODAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have NOW function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.

1 thought

Leave a Comment

Your email address will not be published.

  1. I am trying to use today function in three separate places but I want it to remain static. I want it to show when another column reaches 100%, when another column has anything typed into it, and I want it to update each time a cell is edited. I actually figured out the last one with VBA but I am having a lot of trouble.