I'm having a tough time figuring out a working days calculation and needed some help. First a little background about my data source. The dates in my source have only 1 date for each month. It looks like this.
Obviously, just doing a calculation like DATEDIFF('day', DATETRUNC('month',TODAY()), TODAY()) + 1 should work... However...
Complicating the matter is that not all days of the week are work days. By this I mean Sundays are excluded.
What I need is a way to automatically count the number of work days from the first of the current month to today that won't include Sunday.
Any help would be much appreciated.