You can still use networkdays, just include the Fridays or Mondays in the
holidays part and they won't be included,
that is certainly both shorter and easier than adding a formula that
subtract all Fridays/Mondays for networkdays
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Nelson" wrote in message
...
Hello,
I'm trying to calculate the total number of days availabe between two
dates.
I know that I can use Networkdays, but that will get me Monday to Friday.
Now, I need to know how can I calculate the number of days available btw
the
dates BUT Monday to Thursday (or Tuesday to Friday)?
Thank you in advance,
Nelson