Excel to calculate date based on no of days

Copper Contributor

Hi,

 

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.

Vignesh2112_1-1655023739619.png

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

 

Thanks

 

1 Reply

@Vignesh2112 

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.