Resolve Excel formulas returning zero for date ranges by fixing text-to-date mismatches and correcting SUMIFS syntax.