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

    Days Left In Month with Exclusion


      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.