View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default calculate number of days btw dates

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