Exlude Friday & Saturday

[#1]

Hi,

How to exclude Friday and Saturday weekday.

Suppose I have the Date from Start Date - 01/01/2013 to End Date - 31/03/2013.

Note : I want the count of day including Saturday and Sunday.

Thanks & Regards,

Amit Kumar

[rbecher · Accepted solution]

Hi Amit,

maybe this helps: shift the start and end date (consider Friday and Saturday as Weekend)

= networkdays(StartDate +1, EndDate +1)

- Ralf