Creation of a timeline automation

[TatianadeWind]

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	Creative kick off call / Assets received (We ask for layered PSDs, fonts, logos, videos and any other assets required to be used) *
Day 4	Storyboard sent from JustPremium by EOP
Day 5	Storyboard Feedback sent by Agency (If feedback is extensive this cycle will repeat for 2 additional days).
Day 8	V1 creative units sent for review by JustPremium by EOP.
Day 9	Consolidated Feedback sent from Agency by EOP.
Day 10	V2 creative sent for approval by JustPremium by EOP (all 3rd party tracking provided by agency for implementation)
Day 11	Approval received from Agency
Day 12	QA testing
Day 13	Tag creation
Day 14	JustPremium campaign set up/LIVE

What we know in general is Day 14 for instance 22 of January - does Excel can calculate week-end and time needed (ex: between day 1 and 4 or between day 5 and 8) and generate the right dates to this timeline? If yes what would be the process? 

Many thanks for your help. 

Tati

[#2]

@TatianadeWind 

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.