Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Table of contents
1.
Introduction
2.
TODAY Function
2.1.
Return value
2.2.
Syntax
2.3.
Examples
3.
NOW Function
3.1.
Return value
3.2.
Syntax
3.3.
Examples
4.
FAQs
5.
Key Takeaways
Last Updated: Mar 27, 2024

Today and Now Function

Author Yukti Kumari
1 upvote
Master Python: Predicting weather forecasts
Speaker
Ashwin Goyal
Product Manager @

Introduction

In this article, we are going to learn two very important functions, Today and Now functions in Excel, which makes your task very easier. 

We will see the syntax of the functions, their uses, return values, formats, and the function arguments in detail. 

Moreover, to give you more clarity, we will also see a few examples of functions and their expected results.

Let’s get started. 

TODAY Function

The TODAY function is useful for displaying the current date on the worksheet whenever you open it. Moreover, we can also use it for calculating intervals when you pass the TODAY() function as an argument to the YEAR function and compute the difference between two dates like YEAR(TODAY()) - 2001. 

Return value

The TODAY function returns the serial number of the current date. Excel uses the date-time code as the serial number for calculating the date and time.

Syntax

The syntax is TODAY(), and the function takes no arguments.

Examples

In this section, we will see the different ways in which one can use the TODAY() function in Excel.

  • Formula: =TODAY()
    It returns the current date, like 16/03/2022.
     
  • Formula: =DAY(TODAY())
    It returns the current day number of the month and can range from 1 to 31. 
     
  • Formula: =MONTH(TODAY())
    It returns the month number of the current date. Like if the current month is April, it will return 4.
     
  • Formula: =DATEVALUE("1/1/2025")-TODAY()
    It returns the number of days between the current date and the date “1/1/2025”.
     
  • Formula: =TODAY()+10
    It returns the date after 10 days from the current date. So, if the current date is 16/03/2022, it will return 26/03/2022.
Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

NOW Function

The NOW function displays the current date and time, and the value gets updated every time you open the worksheet. It helps calculate the values based on the current date and time.

Return value

The function returns the serial number of the current date and time. Note that in excel, the dates are stored as sequential serial numbers. For instance, the date 1st January,1900 is serial number 1.

Syntax

The syntax is NOW(), and the function takes no arguments.

Examples

In this section, we will see the different ways in which one can use the NOW() function in Excel.

  • Formula: =NOW()
    It returns the current date and time. For example, it can return 11/6/2021 19:03
     
  • Formula: =NOW()-0.25
    It returns the date and time 6 hours ago, i.e. 0.25*24 hours ago.
     
  • Formula: =NOW()+10
    It returns the date and time of 10 days from now.

FAQs

  1. Does the now function in Excel update automatically?
    It is automatically refreshed anytime the workbook is opened, or a change is made. It can also be manually refreshed by pressing F9.
     
  2. What is the use of today function in Excel?
    The TODAY function in Excel returns the current date. 
     
  3. Where does Excel's now function retrieve the date and time from?
    An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell.
     
  4. How do you automatically add today's date so that it does not change later?
    Press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
     
  5. What is the purpose of the Now function?
    The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time and have that value updated each time you open the worksheet.

Key Takeaways

In this article, we have extensively discussed Today and Now Function

We hope that this blog has helped you enhance your knowledge regarding Today and Now Function, and if you would like to learn more other useful functions available in excel, check out our articles How to create a Calendar in ExcelVLOOKUP FunctionDay, Month, Year FunctionDays and DATEDIF Function.

Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc. 

Enrol in our courses and refer to the mock test and problems available.

Take a look at the interview experiences and interview bundle for placement preparations.

Do upvote our blog to help other ninjas grow. 

Happy Coding!

Next article
Days, Month and Year Function
Live masterclass