Sumproduct and weekday from mm/dd/yyyy format?

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

 

[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

 

[Mike H]

Again,

See you other post

Mike

 

[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