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