So, if the YEAR formula returns a value like 2024 but the cell is formatted using a custom date format such as “yyyy”, Excel treats 2024 as a date serial number, not as a year. Since serial number ...