# 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 — EXCEL FORMULA AND EXAMPLE

=NOW()

• NOW() will get current date and time for current time only use =NOW()-TODAY()

# Dynamic current date and time in Google Sheets

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

# DYNAMIC CURRENT DATE AND TIME — GOOGLE SHEETS FORMULA AND EXAMPLE

=NOW()

• NOW() will get current date and time for current time only use =NOW()-TODAY()