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

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Dynamic current date and time in Excel

How to get dynamic current date and time in Excel?
Dynamic current date and time in Excel

DYNAMIC CURRENT DATE AND TIME — EXCEL FORMULA AND EXAMPLE

=NOW()

Dynamic current date and time in Google Sheets

How to get dynamic current date and time in Google Sheets?
Dynamic current date and time in Google Sheets

DYNAMIC CURRENT DATE AND TIME — GOOGLE SHEETS FORMULA AND EXAMPLE

=NOW()

Other widely used Excel and Google Sheets formulas explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions