Have you copied data from the internet and pasted it in Excel?
It can be very frustrating when the data is messy!
Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.
In my case, I was copying some calendar related data for a template I’m working on and the date values needed correcting.
Download my Excel file
Watch my YouTube video
See how I caught the issue and several ways to fix it.