I use the following formula to determine the remaining number of work days in the month -. In order to meet certain deadlines, our "working" end of the month is 5 work days prior to the actual end of the month. So I use the same formula and subtract 5. The problem is once I reach the actual last 5 workdays of the month, the formula calculates the remaining number of work days as zero or negative. I'd like to use an IF statement that says if the formula is zero or negative, calculate the net work days for the next month. The 5 work days from the end of the current month would be added to the total for the next month, but again 5 days would be subtracted from the end of the next month.
Please Login or Register to view this content.