First off, let me admit my knowledge of worksheet functions extends to the help file. When I need something more complex, I look on the internet and find a formula that does what I need and try to learn something new from it. However, every now and then, I find a formula that uses functions in a way I don't fully understand. I approach the knowledge base of this forum with my question because, frankly, I can't figure this one out...
Originally I needed a formula that would count the number of days that have passed in a given month, sans Saturday/Sunday and company holidays. The following formula does this quite nicely:
Where C1 is a date that can be manually input and the range of A31:A41 is where I can input holidays to omit from the count.
I need a formula (either a modification of this or something new) that will allow the same functionality, but also count Saturday as a work day.
Also, if it isn't too much trouble, some kind of explanation as to what exactly the formula I posted does to determine which days are weekdays would be VERY much appreciated. Like I said, I try to learn from these formulas I find and I can't recall where I found this one to ask the author.
--edit--
Whatever workaround is presented, it can't use the NETWORKDAYS function. I have been unable to get the analysis pack to work on my computer, let alone getting it to work on the computers of the people I send this spreadsheet to.
Bookmarks