Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you looked into Networkdays() function?
Thanks Stefan. I haven't used this function in the past.
I looked at it and it should do the job.