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 ...
AGGREGATE was built to handle messy data from the start.
Excel isn't hard, just learn the right tricks early enough.
🎉 1,400+ downloads this week! Thank you to our growing community.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results