Count Weekend Days

[#1]

Hi,

I have a quick but urgent question. Does anyone know how I could count weekend days. As an example, how could I count the weekend days between StartDate = '2011-04-01' and EndDate = '2011-04-06' which would be 2.

Thanks,

Shane

[#2]

Hi shanejv,

Calculate the total count of days between the duration (StartDate = '2011-04-01' and EndDate = '2011-04-06' ) and subract with the count of Networkdays.

[#3]

Thanks for the response.

I achieved an hour difference between two dates (excluding weekends) by doing this:

Thanks,

S