Consider using the function: WEEKDAY, YEAR, MONTH.
Micky


"wx4usa" wrote:

I have a database in Excel. Column A is Date in mm/dd/yyyy format.
Column G is Sales. I need a Sumproduct formula to return the sales
for Mondays in August 2009. How do I extract Mondays from mm/dd/yyyy
and build the formula? I do have multiple years in the dBase, so it
needs to consider the year too.

Thanks
.