• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Working days with Fridays and Saturdays as Offs

ninad7

Member
Hi,


I am based in Dubai where Friday and Saturday are the weekly Offs. Some have only Fridays. Networkdays calculates working days with Sat/Sun as Offs. Can someone document a function to incorporate Fri/Sat as Offs AND Fri as Off.


To make it really flexible, a function outputting the working days and passed with days to be considered as Offs and Holiday List would be great between Start Date and End Date will be ideal.


Ninad.
 
Hi ninad7,


Take a look here for a solution


http://www.excelforum.com/excel-worksheet-functions/693491-change-weekday-networkdays-functions-for-other-cultures.html
 
Thanks. That did it.


Any idea how that might written as a function/addin such that I don't have to copy/paste the whole formula time and again.
 
Back
Top