Excel - Master Excel's Most Popular Functions: =NOW() and =TODAY() | Excel Tutorial - Episode 1624

1,094 views · Published 22 January 2013 · 4:08 · Indexed 22 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Most Popular Functions =NOW() and =TODAY().

Welcome back to the MrExcel netcast! In today's episode, we're continuing our series on the most popular Excel functions. We'll be covering numbers 12 and 13, which are the NOW and TODAY functions. These two functions are closely related and can be incredibly useful in your daily Excel tasks.

Let's say you have a list of projects with due dates and you need to calculate how many days are left until those due dates. You could manually update a column every day, but that can be time-consuming and prone to errors. This is where the NOW and TODAY functions come in handy. The NOW function returns the current date and time, while the TODAY function returns just the current date.

To use these functions, simply enter "=NOW()" or "=TODAY()" into a cell. You can then use these functions in calculations to determine the number of days until a due date. For example, you can subtract the due date from the TODAY function to get the number of days until the due date. This eliminates the need for manual updates and ensures accurate results.

One thing to note is that the NOW function returns the date and time in a specific format, which may not be ideal for your calculations. In this case, you can use the INT function to convert the date and time to just the date. However, if you only need the date, it's best to use the TODAY function instead.

Another advantage of using the TODAY function is that it automatically updates every day. This means you don't have to worry about updating the cell manually. Plus, it eliminates the issue of rounding errors that can occur when using the NOW function.

In conclusion, the NOW and TODAY functions are powerful tools that can save you time and ensure accuracy in your Excel calculations. Whether you need the current date and time or just the date, these functions have got you covered. So next time you're working on a project with due dates, remember to use the NOW and TODAY functions to make your life easier. Thanks for watching and we'll see you in the next episode of the MrExcel netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/



Over the summer of 2012 MrExcel started a series called "Most Popular [Excel] Functions"... but book writing and updating editions took the lead and our 'Most Popular Functions' series came to a pause.
Today, Bill 'MrExcel' Jelen resumes the Most Popular [Excel] Functions series with the " =NOW " and " =TODAY " Functions. Follow along with Episode #1624 to see the differences between the two -- as well as a brief on " =INT(NOW( " -- and where each can be applied effectively!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Problem Statement: Excel #NOW() and #TODAY()
(1:06) Excel calculate days between two dates
(1:35) Excel function to return current date & time
(2:13) Fractional Days from NOW & Rounding
(3:20) TODAY function in Excel
(3:50) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153409/

This video answers these common search terms:
Calculate days until due
Date and time formatting
Episode 1624
Excel functions
INT function
Learn Excel
Most Popular Functions
NOW function
TODAY function
TODAY vs NOW

More from this channel