Dynamic current date and time in Excel and Google Sheets

=NOW()

Similarly, you can get:

7 days from today or now: =TODAY() + 7

For a cell reference, replace the TODAY() function with your reference cell, for example, =A1+7

7 hours from now: =NOW() + 7/24

For a cell reference, replace the NOW() function with your reference cell, for example, =A1 + 7/24

💡 Make sure your reference cell (A1 in this example) is a time value.

7 months from today or now =EDATE(TODAY(),7)

For a cell reference, replace the TODAY() function with your reference cell, for example, =EDATE(A1,7)

7 years from today or now =DATE(YEAR(TODAY())+7,MONTH(TODAY()),DAY(TODAY()))

For a cell reference, replace the TODAY() function with your reference cell, for example, =DATE(YEAR(A1)+7,MONTH(A1),DAY(A1))

💡 If the month and date are not important and you only want to increase years, you can use =YEAR(A1)+7 or YEAR(TODAY())+7