Use the TODAY function

The TODAY function always displays the current date regardless of when it was opened, and can be used for calculating intervals. 

1. Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.

2. Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.

3. Enter =DAY(TODAY()) to return the current day of the month (1-31), and entering =MONTH(TODAY()) returns the month of the year (1-12).
   
   Tip: Use Ctrl+; (semi-colon) to insert today's date that never changes.

The TODAY function always displays the current date regardless of when it was opened, and can be used for calculating intervals. 

1. Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.

2. Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.

3. Enter =DAY(TODAY()) to return the current day of the month (1-31), and entering =MONTH(TODAY()) returns the month of the year (1-12).
   
   Tip: Use control+; (semi-colon) to insert today's date that never changes. 

The TODAY function always displays the current date regardless of when it was opened, and can be used for calculating intervals. 

1. Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.

2. Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.

3. Enter =DAY(TODAY()) to return the current day of the month (1-31), and entering =MONTH(TODAY()) returns the month of the year (1-12).
   
   Tip: Use Ctrl+; (semi-colon) + Enter to insert today's date that never changes.