Sumproduct and weekday from mm/dd/yyyy format?

W

wx4usa

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.
 
L

Lars-Åke Aspelin

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
 
W

wx4usa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top