Select cell C3 and type an equal sign to begin the formula. Select the cell formulas you want to add to and click Kutools More Convert Refers. In the Save As dialog box open the Save As Type drop-down list and select Excel Add-In.
Type any value in B3 and c3 cells you will see the answer in the D3 cell.
Under Category click Date select the date format you want and then click OK. Heres how to create an addition formula. Now you have applied the formula to every cell in the column. In Excel the Table format can help you to fill the above formula into the new inserted blank rows automatically please do as follows.