Today Function: A Brief The TODAY function in Excel returns the current date and updates automatically whenever the worksheet is opened or changed. This function does not require any arguments and you can apply a date format to display the result correctly. You may need to use the NOW function if you need both the current date and current time. TODAY current date Objective

Value Returned by function



Aim to get the current date

Today Function will return a valid Excel date in serial numbers. Objective

Value Returned by function



Aim to get the current date

Today Function will return a valid Excel date in serial numbers. Objective

Value Returned by function Objective Objective Value Returned by function Value Returned by function Aim to get the current date

Today Function will return a valid Excel date in serial numbers. Aim to get the current date Aim to get the current date current date Today Function will return a valid Excel date in serial numbers. Today Function will return a valid Excel date in serial numbers. valid Excel date Today Function: A Syntax =TODAY() =TODAY() The TODAY function returns the current date and updates automatically whenever the worksheet is refreshed. The result is a standard Excel date and to display it correctly, apply a date format. You can also customize the format as needed as shown in the below image. TODAY date format Using Today Function with Practical Examples: Formula

Result

Current day of the week



=TEXT(TODAY(),"DDDD")

Thursday

Current day of the week



=TEXT(TODAY(),"MMMM")

March

Current month name



="Q"&ROUNDUP(MONTH(TODAY())/3,0)&"-"&YEAR(TODAY())

Q1-2025

Current quarter



=TODAY()+5*365

12 March 2030

5 years from today



=IF(MOD(YEAR(TODAY()),4)=0,"Yes","No")

No

Check if current year is a leap year



=EOMONTH(TODAY(),0)

31 March 2025

Last day of the current month



=EOMONTH(TODAY(),0)+1

01 April 2025

First day of next month



=EOMONTH(TODAY(),1)

30 April 2025

Last day of next month



=DATE(YEAR(TODAY())+1,1,1)

01 January 2026

First day of next year



=DATE(YEAR(TODAY()),12,31)

31 December 2025

Last day of the current year Formula

Result

Current day of the week



=TEXT(TODAY(),"DDDD")

Thursday

Current day of the week



=TEXT(TODAY(),"MMMM")

March

Current month name



="Q"&ROUNDUP(MONTH(TODAY())/3,0)&"-"&YEAR(TODAY())

Q1-2025

Current quarter



=TODAY()+5*365

12 March 2030

5 years from today



=IF(MOD(YEAR(TODAY()),4)=0,"Yes","No")

No

Check if current year is a leap year



=EOMONTH(TODAY(),0)

31 March 2025

Last day of the current month



=EOMONTH(TODAY(),0)+1

01 April 2025

First day of next month



=EOMONTH(TODAY(),1)

30 April 2025

Last day of next month



=DATE(YEAR(TODAY())+1,1,1)

01 January 2026

First day of next year



=DATE(YEAR(TODAY()),12,31)

31 December 2025

Last day of the current year Formula

Result

Current day of the week Formula Formula Result Result Current day of the week Current day of the week =TEXT(TODAY(),"DDDD")

Thursday

Current day of the week =TEXT(TODAY(),"DDDD") =TEXT(TODAY(),"DDDD") Thursday Thursday Current day of the week Current day of the week =TEXT(TODAY(),"MMMM")

March

Current month name =TEXT(TODAY(),"MMMM") =TEXT(TODAY(),"MMMM") March March Current month name Current month name ="Q"&ROUNDUP(MONTH(TODAY())/3,0)&"-"&YEAR(TODAY())

Q1-2025

Current quarter ="Q"&ROUNDUP(MONTH(TODAY())/3,0)&"-"&YEAR(TODAY()) ="Q"&ROUNDUP(MONTH(TODAY())/3,0)&"-"&YEAR(TODAY()) Q1-2025 Q1-2025 Current quarter Current quarter =TODAY()+5*365

12 March 2030

5 years from today =TODAY()+5*365 =TODAY()+5*365 12 March 2030 12 March 2030 5 years from today 5 years from today =IF(MOD(YEAR(TODAY()),4)=0,"Yes","No")

No

Check if current year is a leap year =IF(MOD(YEAR(TODAY()),4)=0,"Yes","No") =IF(MOD(YEAR(TODAY()),4)=0,"Yes","No") No No Check if current year is a leap year Check if current year is a leap year =EOMONTH(TODAY(),0)

31 March 2025

Last day of the current month =EOMONTH(TODAY(),0) =EOMONTH(TODAY(),0) 31 March 2025 31 March 2025 Last day of the current month Last day of the current month =EOMONTH(TODAY(),0)+1

01 April 2025

First day of next month =EOMONTH(TODAY(),0)+1 =EOMONTH(TODAY(),0)+1 01 April 2025 01 April 2025 First day of next month First day of next month =EOMONTH(TODAY(),1)

30 April 2025

Last day of next month =EOMONTH(TODAY(),1) =EOMONTH(TODAY(),1) 30 April 2025 30 April 2025 Last day of next month Last day of next month =DATE(YEAR(TODAY())+1,1,1)

01 January 2026

First day of next year =DATE(YEAR(TODAY())+1,1,1) =DATE(YEAR(TODAY())+1,1,1) 01 January 2026 01 January 2026 First day of next year First day of next year =DATE(YEAR(TODAY()),12,31)

31 December 2025

Last day of the current year =DATE(YEAR(TODAY()),12,31) =DATE(YEAR(TODAY()),12,31) 31 December 2025 31 December 2025 Last day of the current year Last day of the current year Practical today function formula with output results as examples. Find the Next Friday from Today: If you want to schedule a meeting every Friday, and you need to find the next Friday from today (present day). You can use the below formula. =TODAY()+MOD(6-WEEKDAY(TODAY()),7) =TODAY()+MOD(6-WEEKDAY(TODAY()),7) Formula to find the next Friday and Tuesday from today using TODAY function Number Value

Day Name



1

Sunday



2

Monday



3

Tuesday



4

Wednesday



5

Thursday



6

Friday



7

Saturday Number Value

Day Name



1

Sunday



2

Monday



3

Tuesday



4

Wednesday



5

Thursday



6

Friday



7

Saturday Number Value

Day Name Number Value Number Value Day Name Day Name 1

Sunday 1 1 Sunday Sunday 2

Monday 2 2 Monday Monday 3

Tuesday 3 3 Tuesday Tuesday 4

Wednesday 4 4 Wednesday Wednesday 5

Thursday 5 5 Thursday Thursday 6

Friday 6 6 Friday Friday 7

Saturday 7 7 Saturday Saturday =TODAY()+MOD(3-WEEKDAY(TODAY()),7), you can change the number to check for the different days in the coming week. =TODAY()+MOD(3-WEEKDAY(TODAY()),7) Calculate AGE using Today function: You can use the today function along with the year function to calculate the AGE of the person. to do this, you must need to enter the proper date values. Using the below formula to calculate the age from birthday with TODAY Function. The formula to do this is, =YEAR(TODAY())-YEAR(C4) =YEAR(TODAY())-YEAR(C4) or =DATEDIF(C4,TODAY(),"Y") =DATEDIF(C4,TODAY(),"Y") or =IF(ISNUMBER(C4), DATEDIF(C4,TODAY(),"Y"), "Invalid Date") =IF(ISNUMBER(C4), DATEDIF(C4,TODAY(),"Y"), "Invalid Date") Display Time along with Today Function: you can use the time function along with the Today function to print current date with the time. =TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM") =TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM") The output of the above formula is , Formula to print current date with time using TODAY Function Other formulas with time function to print today with time output with multiple formats, Formula

Result



=TEXT(TODAY(), "DD-MMM-YYYY")

13-Mar-2025



=TEXT(TODAY(), "DDDD, DD-MMM-YYYY")

Thursday, 13-Mar-2025



=TEXT(TODAY(), "MMMM YYYY")

March 2025



=TEXT(TODAY(), "YYYY-MM-DD")

2025-03-13



=TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM")

13-Mar-2025 04:13 PM



=TEXT(TODAY()+1, "DD-MMM-YYYY")

14-Mar-2025



=TEXT(TODAY()-1, "DD-MMM-YYYY")

12-Mar-2025 Formula

Result



=TEXT(TODAY(), "DD-MMM-YYYY")

13-Mar-2025



=TEXT(TODAY(), "DDDD, DD-MMM-YYYY")

Thursday, 13-Mar-2025



=TEXT(TODAY(), "MMMM YYYY")

March 2025



=TEXT(TODAY(), "YYYY-MM-DD")

2025-03-13



=TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM")

13-Mar-2025 04:13 PM



=TEXT(TODAY()+1, "DD-MMM-YYYY")

14-Mar-2025



=TEXT(TODAY()-1, "DD-MMM-YYYY")

12-Mar-2025 Formula

Result Formula Formula Result Result =TEXT(TODAY(), "DD-MMM-YYYY")

13-Mar-2025 =TEXT(TODAY(), "DD-MMM-YYYY") =TEXT(TODAY(), "DD-MMM-YYYY") 13-Mar-2025 13-Mar-2025 =TEXT(TODAY(), "DDDD, DD-MMM-YYYY")

Thursday, 13-Mar-2025 =TEXT(TODAY(), "DDDD, DD-MMM-YYYY") =TEXT(TODAY(), "DDDD, DD-MMM-YYYY") Thursday, 13-Mar-2025 Thursday, 13-Mar-2025 =TEXT(TODAY(), "MMMM YYYY")

March 2025 =TEXT(TODAY(), "MMMM YYYY") =TEXT(TODAY(), "MMMM YYYY") March 2025 March 2025 =TEXT(TODAY(), "YYYY-MM-DD")

2025-03-13 =TEXT(TODAY(), "YYYY-MM-DD") =TEXT(TODAY(), "YYYY-MM-DD") 2025-03-13 2025-03-13 =TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM")

13-Mar-2025 04:13 PM =TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM") =TEXT(NOW(), "DD-MMM-YYYY HH:MM AM/PM") 13-Mar-2025 04:13 PM 13-Mar-2025 04:13 PM =TEXT(TODAY()+1, "DD-MMM-YYYY")

14-Mar-2025 =TEXT(TODAY()+1, "DD-MMM-YYYY") =TEXT(TODAY()+1, "DD-MMM-YYYY") 14-Mar-2025 14-Mar-2025 =TEXT(TODAY()-1, "DD-MMM-YYYY")

12-Mar-2025 =TEXT(TODAY()-1, "DD-MMM-YYYY") =TEXT(TODAY()-1, "DD-MMM-YYYY") 12-Mar-2025 12-Mar-2025 That’s it.

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

Arweave

What is Excel XLFN? -> Excel24x7

How to Calculate Age from Date of Birth in Excel? -> Excel24x7!

View Website Here

Read My Stories

Too Long; Didn't Read

Make resilience your competitive advantage

How to Use Excel TODAY Function? -> Excel 24x7

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Excel Formulas for Assigning Categories by Value Range Using Functions!

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Excel Formulas for Assigning Categories by Value Range Using Functions!

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps