TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (2023)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (1)

TODAY in Excel (Table of Contents)

  • TODAY in Excel
  • TODAY Formula in Excel
  • How to Use TODAY Function in Excel?

TODAY in Excel

Today function in excel is the simplest type of function, which just returns today’s date in the Month, Date, Year sequence of MMDDYYYY format. It can be on any day of the year, and if we are using the Today function, it will only return the date on which we are performing the Today function in excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)Price View Courses120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access 4.9 (64,183 ratings)

Definition:

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:

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (10)

How to Use TODAY Function in Excel?

TODAY in Excel is very simple and easy to use. Let us understand the working of the TODAY function in excel by some TODAY Formula example. A TODAY function can be used as a worksheet function and as a VBA function.

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

Example #1

With the help of the Today function in excel, I need to find out today’s or current date in the cell “D8”. Let’s apply the TODAY function in cell “D8”. Select the cell “D8” where the TODAY function needs to be applied.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (11)

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, the TODAY function will appear in select a function box. Double click on the TODAY function.

(Video) Using the Excel Today Function to Set Target Dates

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (12)

A pop up appears saying, “this function takes no arguments”. Click OK.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (13)

=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 (Formula, Examples) | How to Use TODAY Function ? (14)

Example #2

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 in excel (Formula, Examples) | How to Use TODAY Function ? (15)

=TODAY()+B13 is entered in a cell “D13”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (16)

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 Excel are stored as numbers. Therefore, we can simply add +7 to return an output.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (17)

Example #3

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”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (18)

Returns the current month of the year (1 – 12); the current month is November; therefore, it results or returns the output value 11.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (19)

(Video) Excel - TODAY Function

B) Today function is used along with the year function to find out the current year

=YEAR(TODAY()) formula is used in cell “C23”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (20)

Returns year number. i.e. 2018.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (21)

C) Today function is used along with day function to find out current day

=DAY(TODAY()) formula is used in cell “C17”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (22)

Returns the current day of the month (1 – 31); the current day of a month is the 15th day; therefore, it results or returns the output value 16.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (23)

D) Today function is used along with weekday function to find out the current week

In general, as we input the 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 the 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”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (24)

It returns the value 6; it is the corresponding today’s day of the week.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (25)

Example #4

In the below-mentioned example, if the date of birth of the person is mentioned, we can easily find out the person’s current age with the help of TODAY Function. To calculate the person’s current age, the 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.

(Video) How to Use the TODAY Function in Excel (Useful Examples Included)

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”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (26)

i.e. =(TODAY()-G8)/365

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.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (27)

It will return the exact age of a person. i.e. 36.52 (Year with the decimal number).

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (28)

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”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (29)

i.e. =INT((TODAY()-G9)/365).

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (30)

It will return the age of a person. i.e. 36 (Year without decimal number)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (31)

C) TODAY Function along with YEARFRAC Function – To Find out Age,

let’s know about the YEARFRAC function; the 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.”

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (32)

(Video) How to Use TODAY Function in Excel

i.e. =YEARFRAC(G10, TODAY(), 1)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (33)

It will return the age of a person. i.e. 36.50 (Year with a decimal number)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (34)

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”.

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (35)

i.e. =DATEDIF(G11, TODAY(), “y”)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (36)

In the backend, the 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)

TODAY in excel (Formula, Examples) | How to Use TODAY Function ? (37)

Things to Remember

Before applying the 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 the shortcut key, i.e. Ctrl +;

Parentheses in the TODAY function are compulsory, as the function doesn’t expect any argument or parameter.

Recommended Articles

This has been a guide to TODAY Excel Function. Here we discuss the TODAY Formula in Excel and how to use the TODAY Function in Excel and practical examples and downloadable excel templates. You can also go through our other suggested articles –

  1. DAY Formula in Excel
  2. Excel DAY Function
  3. WEEKDAY Formula in Excel
  4. NETWORKDAYS Excel Function

Popular Course in this category

Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses|23 Hands-on Projects |140+ Hours |Verifiable Certificate of Completion 4.8 Price View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
(Video) TODAY function in Excel - current date continuously updated

0 Shares

Videos

1. Excel TODAY Function | Formula | How to use TODAY Function in Excel?
(WallStreetMojo)
2. How to use TODAY function in Excel
(Excel Tip)
3. How to Use NOW Function in Excel
(Excel 10 tutorial)
4. Excel 2013: The Today Function
(KnowledgeWave)
5. TODAY Formula in Excel
(TrumpExcel)
6. Excel 2016 - NOW Function - How To Add Current Date Formula in MS Office - Today Functions Formulas
(Professor Adam Morgan)
Top Articles
Latest Posts
Article information

Author: Patricia Veum II

Last Updated: 11/09/2022

Views: 6225

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Patricia Veum II

Birthday: 1994-12-16

Address: 2064 Little Summit, Goldieton, MS 97651-0862

Phone: +6873952696715

Job: Principal Officer

Hobby: Rafting, Cabaret, Candle making, Jigsaw puzzles, Inline skating, Magic, Graffiti

Introduction: My name is Patricia Veum II, I am a vast, combative, smiling, famous, inexpensive, zealous, sparkling person who loves writing and wants to share my knowledge and understanding with you.