TODAY in Excel (Table of Contents)
TODAY in Excel
- TODAY function is an inbuilt function in excel that is categorized under DATE & TIME function. It is used as worksheet & VBA function in excel.
- It is used as a part of a formula in a cell of a worksheet & also integrated with other complex excel functions. (workday, month, int, dated if, year frac & various other date and time formulas of excel)
- TODAY function in Excel is useful for calculating intervals between two dates, to find out the person age & for calculating date gap i.e. maturity in policy, billing & amount payback.
- TODAY function in Excel was introduced from Excel 2007 version onwards.
- Today function in Excel results in the current date of the system (PC or computer or laptop), i.e. Based on system settings when the systems date is changed, even in today function automatically it gets changed to system date. Because of this recalculation of current date & time, today function is also called as a Volatile function.
- The value of TODAY keeps on changing based on the current date.
TODAY function in Excel returns today’s or current date regardless of when you open the workbook.
TODAY Formula in Excel
Below is the TODAY Formula in Excel :
Explanation of TODAY Function in Excel
TODAY Function is very easy to use and simple function with no input arguments, it is used as or with empty parenthesis.
How to Use TODAY Function in Excel?
TODAY in Excel is very simple and easy to use. Let understand the working of TODAY function in excel by some TODAY Formula example. A TODAY function can be used as a worksheet function and as VBA function.
TODAY in Excel Example #1 – TODAY’S Date
With the help of Today function in excel, I need to find out today’s or current date in the cell “D8”.
Let’s apply TODAY function in cell “D8”. Select the cell “D8” where TODAY function needs to be applied.
Click the insert function button (fx) under formula toolbar, a dialog box will appear, Type the keyword “TODAY” in the search for a function box, TODAY function will appear in select a function box. Double click on TODAY function.
A pop up appears saying “this function takes no arguments”.
=Today() function returns today’s date i.e. 11/16/18.
Here, no need to input any arguments, it is used as or with empty parenthesis.
TODAY in Excel Example #2 – Addition of Week (7 days) To TODAY’S Date
To add 7 days or week to the current date, need to enter the following formula in a cell:
=TODAY()+7 OR =TODAY()+B13
Here either cell reference(B13) or +7 is used along with today function.
=TODAY()+B13 is entered in a cell “D13”.
It returns the output value 11/23/18.
In the backend, here =TODAY()+B13 formula adds 7 days to today’s date. The dates in the excel are stored as numbers. Therefore, we can simply add +7 to return an output.
TODAY in Excel Example #3 – To Find out Month Number, Year & Day
Today function is also used with other functions as a day, month, year & weekday function.
A) Today function is used along with month function to find out current month number
=MONTH(TODAY()) formula is used in cell “C20”.
Returns the current month of the year (1 – 12), the current month is November, therefore it results or returns the output value 11.
B) Today function is used along with year function to find out the current year
=YEAR(TODAY()) formula is used in cell “C23”.
Returns year number. i.e. 2018.
C) Today function is used along with day function to find out current day
=DAY(TODAY()) formula is used in cell “C17”.
Returns the current day of the month (1 – 31), the current day of a month is 15th day, therefore it results or returns the output value 16.
D) Today function is used along with weekday function to find out current week
In general, as we input weekday function, It Returns the day of the week corresponding to a date. It will return a number between 1 to 7, the number which results in a particular or specific day of that week.
Weekday function by default, if the day is Sunday, it returns 1.
if the day is Saturday, it returns 7.
Let’s look out how the WEEKDAY function along with TODAY function works in Excel.
WEEKDAY function is used along with today function to check the day of the week.
=WEEKDAY(TODAY()) formula is used in cell “C26”.
It returns the value 6, it is the corresponding today’s day of the week.
TODAY in Excel Example #4 – To Find out Age using Date of Birth
In the below-mentioned example, if the date of birth of the person is mentioned, we can easily find out the current age of the person with the help of TODAY Function.
To calculate the current age of the person, Today function alone can be used or today function is merged or integrated with YEARFRAC, INT & DATEDIF function.
A) TODAY Function – To Find out Age Using Date of Birth
With the help of today function, we can find out Age by subtracting the birth date from the current date.
In the below-mentioned example, Birthdate is mentioned in cell G8 & today’s date in cell H8.
Today function is applied in the cell “J8”.
In the backend, the first part of the formula (TODAY()-G8) results in a difference between today’s date & birthdate, then that number is divided by the 365, to get the age of the person in years.
It will return the exact age of a person. i.e. 36.52 (Year with the decimal number).
B) TODAY Function along with INT Function – To find out Age
INT function is used along with TODAY function to round a decimal down to the nearest integer (For age).
In the below-mentioned example, Birthdate is mentioned in cell G9 & today’s date in cell H9.
INT function along with Today function is applied in the cell “J9”.
It will return the age of a person. i.e. 36 (Year without decimal number)
C) TODAY Function along with YEARFRAC Function – To Find out Age
let’s know about YEARFRAC function, YEARFRAC function returns a decimal value that represents fractional years between two dates. i.e. Syntax is =YEARFRAC (start_date, end_date, [basis]) it returns the number of days between 2 dates as a year
Basis – Usually 1 is used, it informs Excel to divide the actual number of days per month by the actual number of days per year.
In the below-mentioned example, Birthdate is mentioned in cell G10 & today’s date in cell H10.
YEARFRAC function along with Today function is applied in the cell “J10”
i.e. =YEARFRAC(G10, TODAY(), 1)
It will return the age of a person. i.e. 36.50 (Year with a decimal number)
D) TODAY Function Along with DATEDIF Function – To Find out AGE
DATEDIF function along with today function can return the difference between two dates in years
In the below-mentioned example, Birthdate is mentioned in cell G11 & today’s date in cell H11.
DATEDIF function along with Today function is applied in the cell “J11”.
i.e. =DATEDIF(G11, TODAY(), “y”)
In the backend, DATEDIF formula with the “y” unit calculates the age in years.
It will return the age of the person. i.e. 36 (Year without decimal number)
Things to remember about the TODAY Function in Excel
Before applying TODAY function in Excel, if the cell is in General format, we have to convert that format into date format.
To enter a static or Today’s date in a cell, Click on shortcut key i.e. Ctrl +;
Parentheses in TODAY function are compulsory, as the function doesn’t expect any argument or parameter.
This has been a guide to the TODAY in Excel. Here we discuss the TODAY Formula in Excel and how to use the TODAY Function in Excel along with practical examples and downloadable excel templates. You can also go through our other suggested articles –