Multiple duration columns

Christy Kooiman

Can you have 2 duration columns in a project plan that takes into consideration weekends and holidays? Right now the current duration column does but I need another duration column for our baselines and not sure how to get that to exclude holidays and weekends like the regular duration column does?

Genevieve P.

Hi @Christy Kooiman

The way I would do this is by using the NETWORKDAYS function to generate the duration. At the end of the function you can identify a list of holidays to exclude, see: NETWORKDAYS Function.

Here are some other Community threads with examples that may help:

Networkday formula with Cross Sheet Reference to Holidays Sheet

Networkdays between a date and today

Cheers,

Genevieve