If you want to extract the month or day from a date instead of the year, you can use the MONTH or DAY formula instead. These formulas work in the same way as the YEAR formula, but extract the month or day rather than the year.