The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY with a date number format. If you need current date and time, use the NOW function.
Purpose: Get the current date
Return value: Excel date as a serial number
Syntax
=TODAY ()
Example:
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:
=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