How to calculate network days

[simasarry123]

I am trying to calculate KPI days that should not include weekends. Eg - If KPI due date is 5 days from today, it should automatically exclude any saturday / sunday that falls in between , if any . So Friday KPI due should actually be on Friday  following week.

[Emmanuel_G]

@simasarry123 

Find in attachement one way of doing that.

Let me know if this solution solves your issue or not.😉

[Emmanuel_G · Accepted solution]

@simasarry123 

Just for fun😉 !

Another method using iterative macro. The first one works too.

   

[ShankerV · Accepted solution]

Hi @simasarry123 

As your requirement is simple, where you need to calculate the KPI for 5 days from today excluding weekends.

Here is one way of doing this.

Many thanks

Shanker V

[binuacs]

@simasarry123 One way of doing this

[simasarry123]

I got stuck at a point since it would give same KPI due for all entries in my sheet. I basically have a KPI due date column with each date being different. I need to arrive at a new kpi due date after eliminating weekends between date document submitted by each customer and kpi due date.

[simasarry123]

Thank you for sharing the workflow. :)

[simasarry123]

@ShankerV - your solution is super easy. I just had to make minor tweaks to the formula and it works perfect without me having to add any extra tools in my workflow. Thanks a lot !

[simasarry123]

@binuacs does this work for multiple KPI dates in the same column? Basically I have a KPI column with different KPI date for each customer based on when they submit a document. I tried this method but it took the same KPI due date for all the customers in my data sheet.

[simasarry123]

Thank you @binuacs @Emmanuel_G and @ShankerV for the solution. Each of these solutions would work I believe but in my situation, I Could arrive at the desired output by using the formula tool to calculate the KPI due date as suggested by Shanker.