AnsweredAssumed Answered

Days Left In Month with Exclusion

Question asked by ZoocMan85 on Jan 29, 2016
Latest reply on Jan 31, 2016 by user19752

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.