Sumproduct and Date format

W

wx4usa

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))
 

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