Counts excluding Non-Business Days

[spetushi]

Hello,

I am trying to generate counts or records that have a 'Return Date' within 2 business days of 'CheckOut Date' for any given Saturday to Friday week range. I am looking for some efficient way to do this by taking into account weekends and e.g. US holidays for a given year. E.g. a book checkout on a Friday is 2-business days old on Tuesday and so on. I have attached sample data for experimentation purposes.

Thank you,

Sokol

[swuehl]

Have you looked into Networkdays() function?

networkdays ‒ QlikView

[spetushi]

Thanks Stefan. I haven't used this function in the past.

I looked at it and it should do the job.