Select Code to Download

Select or download this

    my $statusCaseNumFormula = '=COUNTIF($I$3:$I$1000,$A$';
    my $caseNumFormulaEnder = ')';
...
    $formula = $statusCaseNumFormula . $caseNumFormulaCounter . $caseN
+umFormulaEnder;
    $gray25percentFormat->set_align('right');
    $worksheet->write_formula($row,$col, $formula, $gray25percentForma
+t);

Select or download this

    my $formulaCounter = $row + 1;
    $formula = '=TODAY() - ROUNDDOWN($D$' . $formulaCounter . ',0)';
    $worksheet->write_formula($row, $col, $formula, $dateFormatNormal)
+;