Does anyone have any suggestions as to why the first formula does not calculate the value, but the second formula does? Both formulas are in the same script using Spreadsheet::WriteExcel.
First formula:

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

Second formula:

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

The first formula is actually written in the spreadsheet, but it does not calculate the value. After I open the spreadsheet, I can click on the cell, click on the formula icon (fx) next to the formula bar, hit enter and it calculates the value then, but it does not automatically calculate the value. The second formula is written and calculates just fine.