How to exclude weekends when counting da

In Excel I have a need to count the days from today back to a cell reference and then use that value to divide into a count of records (records per day…). What I can’t seem to figure out is how to count only the weekdays in this range since records are not created on weekends. Any ideas?