How Do I Insert a Dynamic Date in Excel?

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Common Date and Time Functions
Image Credit: Photo courtesy of Microsoft

Excel 2013 has hundreds of functions, but Date and Time Functions are some of the most widely used. Since Excel stores dates as numbers, many Date functions are math-based, such as NETWORKDAYS which calculates the number of work days between two dates. Dynamic date functions, like the NOW function, return the current date and time. Other dynamic date functions will return different types of information so it's beneficial to explore the entire Date and Time category of functions.

Advertisement

Inserting a Dynamic Date

Video of the Day

Step 1

Date and Time Functions
Image Credit: Photo courtesy of Microsoft

Click "Date and Time" on the Formulas tab to reveal the list of common functions.

Advertisement

Video of the Day

Step 2

Choose TODAY
Image Credit: Photo courtesy of Microsoft

Choose "TODAY" from the drop-down list. This function returns only the current date.

Advertisement

Step 3

Click OK in Function Arguments dialog
Image Credit: Photo courtesy of Microsoft

View the formula bar or the active cell to verify the function, which should read: "=TODAY()." Clicking "OK" in the Function Arguments dialog box inserts the function into the active cell.

Advertisement

Dialog box messages for dynamic functions display: "Formula Result = Volatile." In Excel-speak, that means a function re-calculates along with the worksheet. Dynamic functions like TODAY and NOW are volatile.

Advertisement

Inserting a Dynamic Date and Time

Step 1

Date and Time Functions
Image Credit: Photo courtesy of Microsoft

Click "Date and Time" on the Formulas tab to reveal the list of common functions.

Advertisement

Step 2

Choose NOW
Image Credit: Photo courtesy of Microsoft

Choose "NOW" from the drop-down list. This function returns the current date and time.

Advertisement

Step 3

Click OK in Function Arguments dialog
Image Credit: Photo courtesy of Microsoft

View the formula bar or the active cell to verify the function, which should read: "=NOW()." Clicking "OK" in the Function Arguments dialog box inserts the function into the active cell.

Advertisement

Advertisement

references & resources