Excel Date Conversion (EOMONTH, DAY, MONTH, YEAR, DATE)

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

EOMONTH

DAY / MONTH / YEAR

DATE