TODAY in Excel (Table of Contents)
TODAY in Excel
Today function in excel is the simplest type of function which just returns today’s date in Month, Date, Year sequence of MMDDYYYY format. It can be at the any day of the year, if we are using Today function, it will only return the date on which we are performing Today function in excel.
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:
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 a VBA function.
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 the 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”. Click OK.
=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.
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 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.
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
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 –