See attached example below.
I am trying to write a formula that will count workdays, however not in total for a given month, but by day.
I.E. I am trying to count across a row - 1,2,3 and then skip weekends and holidays. Do I need to manually create a table of data with labels like "weekday", "weekend" and "holiday" for 2016 and then write a formula or is there a simpler formula I can write?
I know there is a WORKDAY function in excel, but I don't think that's going to populate what I'm looking for as it will just tell me the total number of workdays for the timeframe.
Thanks in advance!
Bookmarks