Inputting a duration is quite straight forward: just select the appropriate cell and input the desired number of days. The gantt chart will be updated automatically. The Gantt Chart will also consider which working days you selected: Monday to Friday or Monday to Sunday.
The end date is automatically calculated via a formula which uses:
- The Starting date
- The Duration
- The type of calculation (Working Days, which days are weekend days)
In case you would like to build the schedule in retro-planning (starting from the end and building the schedule backward) you can opt for negative duration:
- Input the last day of the task in the cell « Start Date »
- Input the desired duration with minus symbol : for example -5