WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » TODAY Excel Function

TODAY Excel Function

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

TODAY Function In Excel (Today’s Date)

Today function is an excel worksheet date and time function which is used to find out the present system date and time in excel, this function does not takes any arguments also this function auto-updates itself whenever the worksheet is reopened and this function only represents the current system date, not the time, the method to use this function is as follows =Today().

Syntax

Formula

Displaying the Current Time Using TODAY Function

TODAY formula in Excel displays the current time as a time serial number (or a serial number without an associated date):

=NOW()-TODAY()

You need to format the cell with a time format to view the result as a recognizable time. The easiest way is to choose Home->Number->Format Number and then select Time from the dropdown list.

TODAY function Example 3-3

You can also display the time, combined with text. The TODAY date Function that follows displays this text:

The current time is 3:56 AM.

=”The current time is “&TEXT(NOW(),”h: mm AM/PM”)

TODAY function Example 3-4

How to Use TODAY Function in Excel? (with Examples)

You can download this TODAY Function Excel Template here – TODAY Function Excel Template

Example #1

If we want to calculate the number of days of a year for the current date, for example, the excel today’s date is 08/1/2018, and the user wants to calculate the number of days till the current date.

TODAY Example 2

So, the total number of days till the current date is 213

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

TODAY Example 2-1

Now using the TODAY date Function, Year and Date function, we can calculate the number of days of the year for the current date:

The TODAY Formula in Excel is:

=TODAY()-DATE(YEAR(TODAY()),1,0)

TODAY Example 2-2

Example #2

A Service based company named SS Brother Solutions provides the maintenance for Printers. The company has the list of clients with an annual maintenance contract’s (AMC) end date and the amount of AMC for the year 2018. The Manager has been asked to provide the total amount of AMC pending for the current year from the current date.

Client AMC End Date Amount
ABC Company 4/2/2018 $6,000.00
XYZ Company 5/31/2018 $5,500.00
Supreme Company 2/28/2018 $9,043.00
Auber Company 9/19/2018 $10,301.00
HCL Technologies 10/29/2018 $11,049.00
Cistern Limited 6/19/2018 $11,232.00
Apollo Group 5/3/2018 $8,133.00
Akola Software’s 6/15/2018 $8,464.00
Alliant Techs stems 3/1/2018 $9,280.00
BFG Technologies 10/11/2018 $10,561.00
Deluxe Corporation 8/30/2018 $10,877.00
Envision Healthcare 8/20/2018 $8,955.00
Concur Technologies 5/29/2018 $8,690.00
Intercontinental Manufacturing Company 7/16/2018 $10,803.00
ITT Corporation 5/16/2018 $9,387.00
Regions Financial Corporation 6/24/2018 $7,687.00

TODAY Example 3

For the upcoming months Aug, Sep… till Dec, the manager needs to calculate the AMC amount pending.

There are 5 companies whose AMC will be collected on the given AMC end date.

TODAY Example 3-1

In order to calculate the total amount pending, we will use the SUMIF and TODAY date Function to calculate the amount pending for the current year

The TODAY Formula in Excel will be

=SUMIF(B2:B17,”>=”&TODAY(),C2:C17)

TODAY Example 3-2

So, the total AMC amount pending for the upcoming dates is $51,743

Example #3

We have a list of items with their purchase dates, and we need to find the count of the items purchased on the current date.

TODAY function Example 4

So, in order to find the total count number of the item purchased on the current date, we will use the COUNTIF and TODAY Excel function.

The TODAY Formula in Excel will be

=COUNTIF(B2:B21,TODAY())

TODAY function Example 4-2

TODAY Excel Function Video

Recommended Articles

This has been a guide to TODAY Function in Excel. Here we discuss the TODAY Formula in excel and how to use Excel TODAY date Function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • Date Function in VBA
  • MONTH in Excel | Examples
  • YEAR Function in Excel
  • DAY Function
5 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download TODAY Function Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More