Use the TODAY function
https://support.microsoft.com/article/3198a6d7-97b7-4761-b113-9ced400ab66f
The TODAY function displays the current date regardless of when it was opened, and for calculating intervals. It always reflects the current date. Use Ctrl+; (semi-colon) to insert todays date statically. Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days. Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030. 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.
Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.
Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.
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.
DA: 9 PA: 84 MOZ Rank: 88