What Function Do You Use to List Dates in Excel?


Quick Answer

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.

Continue Reading
Related Videos

Full Answer

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

Related Questions