Excel: How to return count for each cell within date range criter.

L

Louisa

I need to return a count if several dates match a criteria on the following:
IF Order date (b2:b50) = < End of week date(z2)
Then go to
IF Order completed date(h2:h50) > end of week date(z2) OR order
completed date(h2:h50) = "" then add to count (incomplete orders)
 

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

Similar Threads

counting the occurrence of specific text within a date range 4
Excel 2010 countifs for date range 3
Count partial dates 1
subtract one cell from each cell in a range and count instances 2
countifs criteria includes date range 4
Counting multiple occcurrences between date range 3
identify which years are contained within a range of dates 2
I want to count occurences between 2 dates. 4

Top