Creation of a timeline automation

%3CLINGO-SUB%20id%3D%22lingo-sub-2008984%22%20slang%3D%22fr-FR%22%3ECreation%20of%20a%20timeline%20automation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008984%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe're%20working%20a%20lot%20with%20timelines%20for%20my%20work%20and%20I%20was%20wondering%20if%20Excel%20is%20able%20to%20auto-calculate%20working%20days%20and%20follow%20a%20precise%20agenda.Here%20is%20an%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22604%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%201%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3ECreative%20kick%20off%20call%20%2F%20Assets%20received%20(We%20ask%20for%20layered%20PSDs%2C%20fonts%2C%20logos%2C%20videos%20and%20any%20other%20assets%20required%20to%20be%20used)%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%204%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EStoryboard%20feels%20from%20JustPremium%20by%20EOP%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%205%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EStoryboard%20Feedback%20feels%20by%20Agency%20(If%20feedback%20is%20extensive%20this%20cycle%20will%20repeat%20for%202%20additional%20days).%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%208%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EV1%20creative%20units%20sent%20for%20review%20by%20JustPremium%20by%20EOP.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%209%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EConsolidated%20Feedback%20sent%20from%20Agency%20by%20EOP.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%2010%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EV2%20creative%20sent%20for%20approval%20by%20JustPremium%20by%20EOP%20(all%203rd%20party%20tracking%20provided%20by%20agency%20for%20implementation)%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%2011%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EApproval%20received%20from%20Agency%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%2012%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EQA%20testing%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%2013%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3ETag%20creation%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2285%22%3E%3CP%3EDay%2014%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22519%22%3E%3CP%3EJustPremium%20campaign%20set%20up%2FLIVE%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we%20know%20in%20general%20is%20Day%2014%20for%20instance%2022%20of%20January%20-%20does%20Excel%20can%20calculate%20weekend%20and%20time%20needed%20(e.g.%20between%20day%201%20and%204%20or%20between%20day%205%20and%20%3CLI-EMOJI%20id%3D%22lia_smiling-face-with-sunglasses%22%20title%3D%22%3Asmiling_face_with_sunglasses%3A%22%3E%3C%2FLI-EMOJI%3E%20%20and%20generate%20the%20right%20dates%20to%20this%20timeline%3F%20If%20yes%20what%20would%20be%20the%20process%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETati%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2008984%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009067%22%20slang%3D%22en-US%22%3ERe%3A%20Creation%20of%20a%20timeline%20automation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909270%22%20target%3D%22_blank%22%3E%40TatianadeWind%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20WORKDAY%20(or%20WORKDAY.INTL)%20function%20-%20see%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-workday-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20WORKDAY%20Function%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20let's%20say%20you%20enter%20the%20numbers%201%2C%204%2C%205%2C%208%2C%209%2C%20...%20in%20A2%2C%20A3%20etc.%3C%2FP%3E%0A%3CP%3EIn%20B2%2C%20enter%20the%20start%20date%2022-Jan-2021.%3C%2FP%3E%0A%3CP%3EIn%20B3%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DWORKDAY(B2%2CA3-A2)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormat%20B3%20as%20a%20date%2C%20then%20fill%20down.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0037.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242205iEDFB04E8EEFD74B3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0037.png%22%20alt%3D%22S0037.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3ESee%20the%20link%20above%20for%20how%20to%20take%20public%20holidays%20into%20account.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 and generate the right dates to this timeline? If yes what would be the process? 

 

Many thanks for your help. 

 

Tati

1 Reply

@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.

 

S0037.png

See the link above for how to take public holidays into account.