Joined: 07 Nov 2018
Online Status: Offline
Posts: 8
Topic: date formula Posted: 10 Dec 2019 at 5:29pm
Hi,
I need to count working days. which are those working days is not counting the holiday days. for example 1 week there are 7 days but because there is sunday the result will be only 6 days. And if there were another holidays so the result will be reduced by the another holidays and the result can be less than 6.
Does anyone can help?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 Dec 2019 at 2:23am
Best case scenario is to have a calendar table with your dates in it and exclude the values identified as holidays.
If that is not possible you can put a really lengthy formula that identifies each holiday and a subtraction process if that holiday falls in your select criteria.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 11 Dec 2019 at 3:58am
Also Ken Hamady (check his website) created a formula that handles most regular holidays. I even modified it for our special holiday schedule at our organization (we always get the day after Thanksgiving off and Christmas Eve, unless a holiday falls on a Sunday).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
