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