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.
Inserting a Dynamic Date
Video of the Day
Step 1
Click "Date and Time" on the Formulas tab to reveal the list of common functions.
Video of the Day
Step 2
Choose "TODAY" from the drop-down list. This function returns only the current date.
Step 3
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.
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.
Inserting a Dynamic Date and Time
Step 1
Click "Date and Time" on the Formulas tab to reveal the list of common functions.
Step 2
Choose "NOW" from the drop-down list. This function returns the current date and time.
Step 3
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.