Correcting your report
The conditional formatting rule that you applied in the last exercise is left on to start with in order to show two ways that dates can be bad.
A date won't be recognized if you add a suffix to the day, such as 26th instead of just 26. Additionally, February 30, 2024 will never exist, so that's also bad.
Let's start by cleaning up the data.
本練習屬於課程
Google 試算表的條件格式
練習說明
- Correct the incorrect dates by removing the "th" from February 26th and delete the entire row with February 30, as there are 0 hours anyway.
- Once the dates are fixed, delete that conditional formatting rule.
