I'd like it to automatically use the current month (which it currently does it just doesn't exclude holidays) - specifically it uses "Sales Order Pick Up Date" (how I define the day my customer picks up the order) to calculate which date the sales order will count for
So to answer your question which month = the current month (if I make it a fixed month I'll have to update this report every month)
I'm trying to calculate two things to make this work:
[Total Weekdays Current Month] # of working days in the month (for current month) excluding holidays
[Weekdays Month To Date] # of working days from the 1st day of this month until today (for current month) excluding holidays
I
