Google Sheet Weekly Report Troubleshooting - Subtask 3

Description

…but the dates in Column B look different too.

3. Ensure the dates in Column B are properly formatted.

Solution

Change the values in Column B to proper date format. For example, B14 in Executive Overview change 11.28.2020 to 11/28/2020.

Explanation

According to Google Sheets Documentation, valid date formats include - or /. Dates using . aren’t interpreted by Sheets as a date, but rather text. Attempting to pass improperly formatted dates to our SUMIFS() formula causes the function to fail.

The simplest resolution is to use Find & Replace to replace all . with / or - in the values found in B14-26.

Below we can see the correct date format being used in Column B. Like magic, all the table cells populate once proper dates are provided.