Excel to calculate date based on no of days

New Contributor



I am looking for an excel sheet to have an automation to enable date and number of days calculation automatically instead of keying in one by one.


The Supplier has to key in the Start date for a task and based on the number of days for the tasks required, the end date should be calculated.


For instance, the supplier will enter the fabrication starts on 4/2/2022 and the number of days required to complete the task. Based on this the end date to be calculated automatically. I can write days formula but I need the columns to be automatically detecting it instead of manual dragging for the entire sheet


Is there a possibility, Please advise




1 Reply


If you turn the data into a table, and if you enter the formula in the first data row, it should automatically be propagated to all existing and new rows.