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.
Résolu ! Accéder à la solution.
Find in attachement one way of doing that.
Let me know if this solution solves your issue or not.😉
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
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.
Thank you for sharing the workflow. :)
@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 !
@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.
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.