Excel remaining days count from today until due date minus weekends

Question

Since everything appears to be working, I'm using =IF([TodayDays]0,0,NETWORKDAYS.INTL(TODAY(),[DueDate],1)), but I have a question. Why The more days left in the calculation, the more days seem to be added on in various date setups.

Since I'm perplexed, I'll pick a start date like 6/16/20 and an end date of 7/16/20, which equals a total of 23 days. However, I only have 25 days remaining after taking weekends into account. How is this even possible?

Answer 1

The problem is that you are not counting the days until the start date too in case the start date falls in the future. The formula you are using had been correct all along. I hope this helps you.