Stop calculating NETWORKDAYS.INTL at the endo of the month

[dheads]

I am currently using NETWORKDAYS.INTL in a workbook to calculate the current workday of the month for the purpose of tracking projected sales & gross. Is there a way to have it stop the calculations at the end of the month? We use a different workbook for each month, and, if I open last months workbook, the tracking numbers are off because the current day shows negative because we are past the last day of the month.

 

[dheads]

Sorry, it is not posting a negative number, it just continues climb each day. My company has downloads restricted, so I am unable to download XL2BB.

 

[Joe4]

What exactly are the formula you are using the cells B4 and E4?
Can you post them here?

 

[dheads]

What exactly are the formula you are using the cells B4 and E4?
Can you post them here?

=NETWORKDAYS.INTL(A2,MAX(TODAY(),B1),11)

 

[dheads]

=NETWORKDAYS.INTL(A2,MAX(TODAY(),B1),11)

Sorry, the above formula is B4, and E4 is below.
=NETWORKDAYS.INTL(A2,A4,11)

 

[Joe4]

Does this do what you want?

=NETWORKDAYS.INTL(A2,MAX(MIN(A4,TODAY()),B1),11)

(not sure what the reference is to to cell B1, as it is currently blank)

 

[dheads]

Does this do what you want?

=NETWORKDAYS.INTL(A2,MAX(MIN(A4,TODAY()),B1),11)

(not sure what the reference is to to cell B1, as it is currently blank)

View attachment 116527

Yes, that does exactly what I need it to do. Also, I am not sure why B1 is referenced either. I removed it, and everything still works as intended. Thank you for your assistance.

 

[Joe4]

You are welcome.
Glad I was able to help!