title: Exclude weekends in calculating difference of two dates in access
body: <p>I am working on an access database for a project and need some help which I cannot solve. I have two date columns Actual Date and Delivery Date which are subtracted from to give a difference eg. Actual date can be 12/05/2017 and Delivery Date can be 16/05/17 subtracted the answer is 4, now my problem is I need to exclude weekends from the calculation, if the actual date is a Thursday and the Delivery Date is a Tuesday the difference should be 4 days and not 6 because the weekends shouldn't count. I need to implement this in Microsoft Access and have the difference show on a report. </p>
  
  <p>If anyone can assist.</p>