Forum Discussion
Creation of a timeline automation
Hello there, We're working a lot with timelines for my work and I was wondering if Excel is able to auto-calculate working days and follow a precise agenda. Here is an example: Day 1 ...
You can use the WORKDAY (or WORKDAY.INTL) function - see Excel WORKDAY Function
For example, let's say you enter the numbers 1, 4, 5, 8, 9, ... in A2, A3 etc.
In B2, enter the start date 22-Jan-2021.
In B3, enter the formula
=WORKDAY(B2,A3-A2)
Format B3 as a date, then fill down.
See the link above for how to take public holidays into account.