Sumproduct and Date format
 

Can I also have the sumproduct formula allso look at the mm/dd/yyyy
date
format in column A and return just specific weekdays such as Tuesdays?
Or Week Number such as week 36.

How do I use sumproduct to return December data from a database if the
range a1:a1000 is formatted mm/dd/yyyy? =sumproduct
((a2:a1000="december")*(b2:b1000))

Sumproduct and Date format
 

Check your other post

"wx4usa" wrote:

Can I also have the sumproduct formula allso look at the mm/dd/yyyy
date
format in column A and return just specific weekdays such as Tuesdays?
Or Week Number such as week 36.

How do I use sumproduct to return December data from a database if the
range a1:a1000 is formatted mm/dd/yyyy? =sumproduct
((a2:a1000="december")*(b2:b1000))