DATE Function Explained
The DATE Function in Microsoft Excel returns the serial number of a particular date. It takes three arguments: year, month, and day. It is useful for calculating the number of days between two dates, or for creating dynamic dates based on user input.
DATE Function Syntax
DATE(year, month, day)
- year: The year argument is a number that represents the year. It must be a value between 0 (zero) and 9999.
- month: The month argument is a number that represents the month. It must be a value between 1 and 12.
- day: The day argument is a number that represents the day. It must be a value between 1 and 31.