Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times. Syntax. DATE(expr). Description. Extracts the date part of the date or datetime expression expr. Examples. SELECT DATE(' ');. Możliwe jest użycie funkcji date() razem z funkcją mktime() w celu . Working almost identical to date() function only as a supplement has the time zone option. For details about how all the other week-related date date functions are handled, see the next sections in this topic. If day is greater than the number of days in the month specified, day adds that number of days to the first day in the month. The value of the year argument can include one to four digits. If year is less than 0 or is or greater, Excel returns the NUM! By default, Microsoft Excel for Windows uses the date system, date functions, which means the first date is January 1, date functions, January 1 always starts the first week of the year and December 31 date functions always in the last week of the year.