I really appreciate any and all help.

I would love to create a macro to simplify my task of adding all occurrences of a particular date (entered as dd/mm/yyyy). The worksheet is designed to track my employee's production by counting the number of contracts they've received per week. The column "Contract Received Date" (AV) is where the employees enter the date.

Currently, I have a function set up to add the total number of occurrences of a particular date for that column. This is quite time consuming because I have to keep changing the function consistent with the date of inquiry. Plus, there are 14 employees, thus 14 different spreadsheets.

I was hoping to create something that would allow me to simply enter a date range, and it would produce a sum for all occurrences in that column.

Thanks