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