TODAY Function In Excel (Today’s Date)
For example, suppose TODAY() returns the current date, e.g., 10-10-2020. Then, to add 7 days to today’s date, we can use the formula =TODAY()+7, which returns the result as 17-10-2020.
Syntax
Displaying the Current Time Using TODAY Function
The 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 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 the TODAY Function in Excel? (with Examples)
Example #1
Suppose we want to calculate the number of days of a year for the current date. For example, in 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 maintenance for printers. The company has a list of clients with an annual maintenance contract’s (AMC) end date and the amount of AMC for 2018. The manager has been asked to provide the total amount of AMC pending for the current year from the current date.
For the upcoming months Aug, Sep, till Dec, the manager needs to calculate the AMC amount pending.
There are five companies whose AMC will be collected on the given AMC end date.
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. Next, we need to find the count of the items purchased on the current date.
So, to find the total count of items purchased on the current date, we will use the COUNTIFUse The COUNTIFThe COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. It is used to count cells that include dates, numbers, or text. For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” read more and TODAY Excel functions.
=COUNTIF(B2:B21,TODAY())
TODAY Excel Function Video
Recommended Articles
This article is a guide to the TODAY Function in Excel. Here, we discuss the TODAY formula in Excel and how to use the Excel TODAY date function, along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel: –
- Date Function in VBADate Function In VBAVBA Date is a date and time function. It returns only the current date as per the system date you are using and has no arguments whatsoever. This function returns the current system date.read moreMONTH in Excel | ExamplesMONTH In Excel | ExamplesThe Month Function is a date function that determines the month for a given date in date format. It takes an argument in a date format and displays the result in integer format.read moreYEAR Function in ExcelYEAR Function In ExcelThe year function in excel is a date function to calculate the year from a given date. This function takes a serial number as an argument and returns a four-digit numeric value representing the year of the given date, formula = year (serial number)read moreDAY FunctionDAY FunctionIn Excel, the DAY function calculates the day value from a given date. This function accepts a date as an argument and returns a two-digit numeric value as an integer value representing the given date’s day. The formula to use this function is =Edate(serial number).read more
