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.
Solved! Go to 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.