Counting down workdays - how to stop at one?

[Avowil]

I want excel to count down the remaining workdays I have, and so far it works like this:

=NET.WORKDAYS.INTL(TODAY()+1;A47;"0010011")

Green = returns the date today
Orange = the last date of work this month (I can a list of working hours on the same spreadsheet)
Blue = days at work is 0, days off (Wed, Sat, Sun) is 1.

Now, what happens everytime there is only one day left, meaning the last day at work, this formula naturally returns the value 0, because there are no more days remaining. This messes up the formula, showing me how many hours I have to work each day to reach my income goal. (You should see my spreadsheet, it's ridiculous.)

What I want to accomplish is for the formula to return the the value 1, even if there are 0 work days left. The formula =MAX should fix this, but for some reason it does not work.

My question: how should the formula look like to accomplish what I want.

Thank you!

 

[Joe4]

Welcome to the Board!

I believe it should look like:
=MAX(NET.WORKDAYS.INTL(TODAY()+1;A47;"0010011");1)

 

[Avowil]

Welcome to the Board!

I believe it should look like:
=MAX(NET.WORKDAYS.INTL(TODAY()+1;A47;"0010011");1)

It really wasn't more complicated than that huh. Haha, thank you very much!

 

[Joe4]

You are welcome!