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.

       

      [Date]

      1/1/2012

      2/1/2012

      3/1/2012

      4/1/2012

      ...

       

      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.