Sometimes, the YEAR function returns the correct value, but Excel displays an unexpected year, such as 1900 or 1905. This occurs when the cell containing the YEAR formula is formatted as a Date ...
Perhaps you've had this experience or something similar: You take your car in for service to a place you've used frequently over the years. You drive in and complete the intake process. You provide ...