For more details, please see Excel date format. By default, Microsoft Excel for Windows uses the 1900 system where Januis represented by the serial number 1.
YearĮxcel interprets the year argument according to the date system set up on your computer. In practice, there may be some unobvious pitfalls that the below tips will help you avoid. The DATE syntax looks crystal clear and straightforward on the surface. The DATE function is available in all versions of Excel 365 - Excel 2007. Month - an integer representing the month of the year, from 1 (January) to 12 (December).ĭay - an integer corresponding to the day of the month, from 1 to 31.
