Excel 2019/365: Date functions: DAY, MONTH, YEAR, DATE, WEEKDAY
How to use Excel's common date functions:
DAY will extract the day of the month from a date serial number.
MONTH will extract the month from a date serial number.
YEAR will extract the year from a date serial number.
DATE will create a date serial number from the month, day, and year integer values.
WEEKDAY will comute the day of the week from a date serial number (1=Sunday, etc.).