my $statusCaseNumFormula = '=COUNTIF($I$3:$I$1000,$A$'; my $caseNumFormulaEnder = ')'; my $caseNumFormulaCounter = 4; my $formula = ''; my $row = 4; $caseNumFormulaCounter = $row + 1; $formula = $statusCaseNumFormula . $caseNumFormulaCounter . $caseNumFormulaEnder; $gray25percentFormat->set_align('right'); $worksheet->write_formula($row,$col, $formula, $gray25percentFormat); #### my $formulaCounter = $row + 1; $formula = '=TODAY() - ROUNDDOWN($D$' . $formulaCounter . ',0)'; $worksheet->write_formula($row, $col, $formula, $dateFormatNormal);