This content has been marked as final.
Show 3 replies
-
1. Re: # of Working weekdays in a month?
Alex Kerin Jun 19, 2012 2:56 PM (in response to Alan Kwan)Do you need partial months (i.e. this month so far)?
-
2. Re: # of Working weekdays in a month?
Alan Kwan Jun 19, 2012 2:58 PM (in response to Alex Kerin)I need all the months (YTD)
-
3. Re: # of Working weekdays in a month?
Joe Mako Jun 19, 2012 10:48 PM (in response to Alan Kwan)The most flexible route in my opinion is to have another data source that is a list of working dates, and use a data blend to pull in the counts as needed. This way you can handle for holidays and other interesting aspects.
If you would like an example, please provide a sample packaged workbook (.twbx) that represents your situation.