I have a column A for the date MM/DD/YYYY format.

I need to have a sumproduct formula look thru the database and return
sales totals for salesperson by month, day and year separately.

For example:
Column
A is date
B is salesperson
C is sales

On a separate page in the workbook, I have a report with these
selection criteria...
A1 is salesperson
A2 is month
A3 is year

I need a formula to return sales for this salesperson for the month
and for the year. Looking ahead, the report/database will span
several years.

Also, is there a way to sumproduct sales by day of the week such as
Tuesdays using the mm/dd/yyyy format?

I seem to struggle with dates and sumproduct.

Any help would be greatly appreciated.