1 Reply Latest reply on Oct 5, 2012 8:19 PM by Alex Kerin

    Working days calculation?

      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.