Q:
# What function do you use to list dates in Excel?

**Use the DATE function in Excel to list dates.** Use the TODAY function to list the current date or the NOW function to list current date and time.

Use the DATE function to combine date elements from different parts of a spreadsheet or to make sure that dates are formatted correctly when entered. The basic function follows the following syntax: =DATE(Year, Month, Day). List the year in four digits and both the month and day in two digits. To use date elements from other cells, use the cell references instead of the year, month and day within the formula.

Enter =TODAY() to insert the current date according to the computer used. Enter =NOW() to display the current date and time. These formulas require no additional information within the parentheses.

Learn more about Software-
Q:
## How do you round numbers in Excel?

A: Though there are several functions in Excel for rounding numbers, the ROUND function is the most basic and the most commonly used. Keep in mind that when u... Full Answer >Filed Under: -
Q:
## How do you calculate variance in Excel?

A: There are two basic ways of calculating variance in Excel using the function VAR or VAR.S. These functions can then calculate variance in several ways: use... Full Answer >Filed Under: -
Q:
## How do you calculate covariance in Excel?

A: To calculate covariance in Excel, use the covariance function. The syntax of the function is: COVARIANCE.P(array1,array2), where array1 and array2 are the ... Full Answer >Filed Under: -
Q:
## How do you use the average formula in Excel?

A: The average function on Excel allows you to find the average of a list of numbers, named ranges, arrays or cell references. This project takes just a few m... Full Answer >Filed Under: