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
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.
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”)
How to Use TODAY Function in Excel? (with Examples)
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.
So, the total number of days till the current date is 213
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)
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 |
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.
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)
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.
So, in order to find the total count number of the item purchased on current date, we will use the COUNTIF and TODAY Excel function
The TODAY Formula in Excel will be
=COUNTIF(B2:B21,TODAY())
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 –
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion
