Exlude Sunday from difference of two date

[#1]

Dear,

I want to exclude only sunday from difference of CallLogDate and CallFinishDate.

for example one call logged on 02-07-2011 11:12:11AM and it resolved on 05-07-2011 5:22:22PM .

in between there is a sunday which i want to remove, Day Difference should be 3.

Thanks for Response....

[kaushiknsolanki]

HI,

   There is a way to exclude the sunday's and saturday's from the given start date and end date.

   The function is.

    Networkdays().

    For more information on this, go to help of qlikview.

Regards,

Kaushik Solanki

[#3]

Dear Kaushik ,

I want to exlude only sunday. Plz help

Thanks and Regards

Vimlesh Gupta

[nagaiank]

In your master calendar, add a field to indicate if a date is working day (1 if a workday, 0 if holiday) and sum this field for the desired date range to get the workday count. This is versatile as this enables you to define your own weekly and other holidays. (For example, in some countries Thursdays and Fridays are weekly holidays instead of Saturdays and Sundays)