calculate number of days btw dates

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

This will exclude Mondays as well as weekends where your start date is in A1 and end date in B1

=NETWORKDAYS(A1,B1)-INT((WEEKDAY(A1-2)+B1-A1)/7)

be aware that if you use the 3rd argument of NETWORKDAYS with this to exclude holidays you should not include any Mondays within your holiday range because they will then be excluded twice and your result will be incorrect

You can exclude Fridays by using the ame formula but with the 2 changed to a 6