Excel TODAY function

Summary

The Excel TODAY function returns the current date, updating automatically when a worksheet recalculates. This function doesn’t require any arguments and is essential for tasks that need the current date, such as dynamic reporting or date tracking.
Syntax
				
					=TODAY()
				
			
This function does not require any arguments.
Return value
The current date as an Excel serial number.

How to use

TODAY is used to insert the current date into an Excel worksheet, updating each time the worksheet recalculates. Press F9 to manually refresh the date. For tasks that require both the current date and time, the NOW function is more suitable.

Examples

Simple TODAY
Inserting Today’s Date:
				
					=TODAY()
				
			
Returns the current date, automatically updating with worksheet recalculations.
TODAY for Date Calculations
Future and Past Date Calculations:
				
					=TODAY() + 30
=TODAY() - 15
				
			
Calculates the date 30 days from today and 15 days before today.
TODAY with EDATE
Using TODAY with EDATE for Future or Past Months:
				
					=EDATE(TODAY(), 3)
=EDATE(TODAY(), -6)
				
			

Calculates the date exactly three months from today and six months prior to today.

TODAY for Reporting
Dynamic Date in Reports:
				
					=TEXT(TODAY(), "dddd, mmmm dd, yyyy")
				
			
Formats today’s date as “Wednesday, April 07, 2021”, useful for report headers or dashboards.

Additional Notes

  • TODAY function only returns the date part, excluding time.
  • Ideal for scenarios that require a dynamically updated current date.
  • The date format can be customized using Excel’s formatting options or the TEXT function for specific formatting requirements.

Related Functions

Excel TEXT function

The Excel TEXT function formats numbers as text using specified formats, crucial for displaying numbers in readable formats.

Excel EDATE function

The Excel EDATE function calculates dates a specific number of months away, aiding in financial planning and scheduling tasks.

Excel NOW function

The Excel NOW function returns the current date and time, updating with each recalculation, perfect for timestamps.

Content Navigation