Counting ONLY business days

[stevop622]

Hi

I have been given a project that involves filtering items that have taken more than 5 business days out (so we are left with just the items that have taken 5 days and less to close out). Is there an easy way to filter out weekends from this count? So that if an item takes 7 days to close out, but 2 of those days are a Saturday and a Sunday then it still gives the total as 5 days.

The problem is that each month has different dates for weekends and the items come in on different days throughout the month.

The raw data will have a column with a start date and a column with an end date (both in form: dd/mm/yyyy).

Please help as this is urgent.

Thanks