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.

Outcomes