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 ...
How to subtotal transactions by conditional date components in Excel Your email has been sent Image: utah778, Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...