title: Excel column autofill (autoincrement with formula)
body: <p><a href="https://i.stack.imgur.com/IQT7V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IQT7V.png" alt="enter image description here" /></a></p>
  <p>500 employees will have 3 hours of work each day (for sample made weekday image sample). so i tried with auto increment for B2 cell &quot;=sum(A2+3)&quot;.
  problem arise when i try to enter Absent data or the cell is cleared the data starts from 3 like in E4 or like in E5. need to Enter AA for absent data for that day.</p>