The DATE function in Google Sheets automatically converts a year, month and day into a date format. Type "=DATE ()" into a cell and press "Enter" to display the current date.

To use this tool to number rows, make the first entry in the column the row function called upon that cell itself. For example, if you have a header row as the first row in your spreadsheet and ...