You can use the YEAR function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function: See below for more examples of formulas that use the DATE function. Note: dates are serial numbers in Excel, and begin on January 1, 1900. Dates before 1900 are not supported. To display date values in a human-readable date format, apply the number format of your choice.
Notes
Date must be a valid Excel date. YEAR will return a #VALUE error on text values.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
