5 Replies Latest reply on Jan 31, 2016 8:37 PM by user19752

    Days Left In Month with Exclusion

    ZoocMan85

      Im trying to figure out how i can do this. This is my setup.

       

      Days in Month  : User Enters Days  Ex. 31

      Days Excluded in Month : User Enters Days to Exclude.  Used for holidays etc. Ex. 5

      --------------------------------------------------------------------------------------------

      Actual Selling Days Left in This Month = 26.

       

      I have a field that calculates how many days are left in a month off the system clock.

       

      Days Left in Month =  Date ( Month ( Get ( CurrentDate )) + 1 ; 0 ; Year ( Get ( CurrentDate ) ) ) - Get ( CurrentDate)

       

      What I'm trying to do is substitute filmmaker from pulling the days off the month from the system clock and basing it off the Actual Selling Days.

       

      How can i do this ? Basically im making a counter. So everyday im subtracting -1 from the 26.