Pinterest Pixel

TODAY Formula in Excel

  What does it do? Gets the date today Formula breakdown: =TODAY() What it means: =TODAY() Have... read more

Download Excel Workbook
Bryan
Posted on

Overview

TODAY Formula in Excel | MyExcelOnline TODAY Formula in Excel | MyExcelOnline

 

What does it do?

Gets the date today

Formula breakdown:

=TODAY()

What it means:

=TODAY()


Have a dynamic formula that needs the current date and you are tired of changing the date everyday? Use Excel’s TODAY Formula to have it update dynamically!

I explain how you can do this below:

TODAY Formula in Excel | MyExcelOnline

Download excel workbookTODAY-FORMULA.xlsx

STEP 1: We need to enter the TODAY function in a blank cell:

=TODAY()

TODAY Formula in Excel

 

And just like that, you already have today’s date!

TODAY Formula in Excel

 

How to Use the TODAY Formula in Excel

 

 

TODAY Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
TODAY Formula in Excel | MyExcelOnline TODAY Formula in Excel | MyExcelOnline
TODAY Formula in Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  How to Calculate Days Between Dates in Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...