EOMONTH | =EOMONTH(start_date, months) | Returns the serial number of the last day of the month before or after a specified number of months and start of month |
DAY | =DAY(serial_number) | Returns the day of the month, a number from 1 to 31 |
MONTH | =MONTH(serial_number) | Returns the month, a number from 1 (January) to 12 (December) |
YEAR | =YEAR(serial_number) | Returns the year of a date, an integer in the range 1900 and 9999 |
DATE | =DATE(year, month, day) | Returns the number that represents the date in Microsoft Excel date-time code. Julian date example |