title: Access SQL Subtract Dates excluding weekends
body: <p>I am able to run the query and update the days from the date it was created. However I would like to exclude weekend days, just Monday thru Friday. </p>
  
  <p>Example: </p>
  
  <pre><code>UPDATE [Table1] SET [Table1].Days = DATE() - [Table1].DateCreated WHERE [Table1].Password = True AND [Table1].Complete = FALSE;
  </code></pre>
  
  <p>This will update the days to the value from the created date to current date, which would be 1,2,3, etc. However I need this to exclude the weekends. I don't run queries very often but I would like create this query.</p>
  
  <p>Please help, thank you.</p>