If the year argument is less than 0 or greater than 9999, a DATE formula will return the #NUM! error.If the year argument is between inclusive, Excel adds the specified number to 1900.If the year argument is between 19 inclusive, Excel uses exactly the value you supplied to create a date.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |