TODAY: How to Insert the TODAY Function in Excel

You want to display today’s date? Or you want to check, if a date written in a cell is the present day? There is an easy formula: =TODAY(). In this article we take a look at the TODAY formula and examine it with an example.

How to use the TODAY formula

The formula is very simple as it has only one part:

=TODAY()

There is no other argument or data needed.

That said, let’s take a look at an example: We got a range of dates, starting from 1st of June to 30th of June. For each day, we want to check, if it is this present day. If yes, we want to return 1, otherwise 0: (the numbers are corresponding to the image above)

today, formula, function, excel, How to Use the TODAY Function
  1. The first part of the IF formula contains the condition. So here we are checking, if cell P4 equals today’s date. 
  2. If the condition is true, the date written in cell P4 is today, then write 1 into cell P5. 
  3. On the other hand, if the condition is not true, write 0 into cell P5. 

Please note that each time when you open the workbook or let Excel calculate it, the TODAY formula will also recalculate and adapt to the current date. You can’t save a certain date with it, for example, the date you last updated the workbook.

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

Leave a comment

Your email address will not be published.

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more