MAX and MIN in the same cell

Im looking to have a the MIN and MAX functions in the same cell. What i need to do is use the number of working days i already have in cell H47 be the max for the result and the Working days left in the month that i already have calculated in cell G47 with a min of 0.

the current formula im using is great but it doesn't stop the number from going above the total number of working days in the month.

Here is the formulas i have so far:

• =MAX(0,$H$47-$G$47)
• =MIN($H$47,NETWORKDAYS(TODAY(),EOMONTH($I$47,0),Holidays!$A$3:$D$24))
• =NETWORKDAYS(I47,I48,Holidays!A3:D24)

added example

Try this in A2:

=MAX(0,NETWORKDAYS(D1,D2,Sheet2!A1:D22)-MIN(NETWORKDAYS(D1,D2,Sheet2!A1:D22),NETWORKDAYS(TODAY(),EOMONTH($D$1,0),Sheet2!A1:D22)))

worked great thank you!!!

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.