=TODAY()

What happen when you enter =TODAY() in Excel

• 
  Returns the current date.

• 
  Returns the yesterday.

• 
  Returns the Tomorrow.

• 
  Returns the Next Week.

What happen when you enter Formula =TODAY()-1

• 
  Returns the current date.

• 
  Returns the yesterday.

• 
  Returns the Tomorrow.

• 
  Returns the Next Week.

What happen when you enter Formula =TODAY()+1

• 
  Returns the current date.

• 
  Returns the yesterday.

• 
  Returns the Tomorrow.

• 
  Returns the Next Week.

What happen when you enter Formula =TODAY()+7

• 
  Returns the current date.

• 
  Returns the yesterday.

• 
  Returns the Tomorrow.

• 
  Returns to the next week.

What happen when you enter Formula =TODAY()-7

• 
  Returns the current date.

• 
  Returns the yesterday.

• 
  Returns to the next week.

• 
  returns from the last Week.

Returns the current day of the month (1 - 31).

• =DAY(TODAY())

• =MONTH(TODAY())

• =YEAR(TODAY())

Returns the current month of the year (1–12).

• =DAY(TODAY())

• =MONTH(TODAY())

• =YEAR(TODAY())

Returns the current year (2023).

• =DAY(TODAY())

• =MONTH(TODAY())

• =YEAR(TODAY())