A max end date for WORKDAY.INTL

[tobysdhc]

Hello,

I am using a WORKDAY.INTL function to determine a due date. Is it possible to have it stop at a certain date. This is my formula =WORKDAY.INTL(B55,10,1,C$77:C$104). If the due date is going to fall after 6/10/15, I would like it to stop on that day. Is that possible?

Thanks,

 

[dreid1011]

Perhaps this:

=MIN(42165,WORKDAY.INTL(B55,10,1,C$77:C$104)

 

[tobysdhc]

Thanks!

 

[dreid1011]

You're welcome.