ID EN
…
#Date and time

TODAY

Excel Functions

Get the current date

Return Value

Excel date as a serial number

Details

The TODAY function returns the current date, and will continually update each time the worksheet is updated. Use F9 to force the worksheet to recalculate and update the value. The value returned by the TODAY function is a standard Excel date. To display the result as a date, apply a date number format. Optionally customize the number format as you like. If you want the current date with a time value, use the NOW function. The TODAY function can be used on its own, or combined with other functions. The formulas below show how the TODAY function can be used in various ways: If you need a static date and time that won't change, you can use the following shortcuts: To enter both values in a single cell, enter the date, a space, then the time.

Examples

Examples

The TODAY function can be used on its own, or combined with other functions. The formulas below show how the TODAY function can be used in various way

EXCEL 
=TODAY()  // current date
=TODAY()-7  // one week in past
=TODAY()+7  // one week in future
=TODAY()+90  // 90 days from today
=EDATE(TODAY(),3)  // 3 months from today
=EDATE(TODAY(),12)  // 1 year from today
=EDATE(TODAY(),-12)  // 1 year in the past
=EOMONTH(TODAY(),-1)+1  // first day of current month
=TODAY()+TIME(18,0,0)  // today at 6:00 PM
=TODAY()+1+TIME(12,0,0)  // tomorrow at noon
Formatting results

The result of TODAY is a serial number representing a valid Excel date. You can format the value returned by TODAY using any standard date format. You

EXCEL 
="The current date is "&TEXT(TODAY(),"mmm d")

See Also

NOW TEXT