Sumproduct and weekday from mm/dd/yyyy format?
 

Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.

Sumproduct and weekday from mm/dd/yyyy format?
 

On Sat, 13 Dec 2008 08:02:35 -0800 (PST), wx4usa
wrote:

Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.

Try this formula:

=SUMPRODUCT((WEEKDAY(A1:A10)=3)*(B1:B10))

Change the 10 in two places to match the number of rows you have.

Hope this helps / Lars-Åke

Sumproduct and weekday from mm/dd/yyyy format?
 

Again,

See you other post

Mike
"wx4usa" wrote:

Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.

Sumproduct and weekday from mm/dd/yyyy format?
 

On Dec 13, 10:09*am, Lars-Åke Aspelin
wrote:
On Sat, 13 Dec 2008 08:02:35 -0800 (PST), wx4usa
wrote:

Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.

Try this formula:

=SUMPRODUCT((WEEKDAY(A1:A10)=3)*(B1:B10))

Change the 10 in two places to match the number of rows you have.

Hope this helps / Lars-Åke

Wow that's really great! Thank you. Lars-Åke