Consider using the function: WEEKDAY, YEAR, MONTH.

I considered it but decided not to use those. Using the TEXT function
reduces the number of array tests that are needed so it's more efficient.

However, in some international locations the TEXT function returns "weird"
results for some date formats. So, if that method fails due to the location
of use then I would use some combination of WEEKDAY, YEAR, MONTH and/or
DATE.

--
Biff
Microsoft Excel MVP


"????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message
...
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
.