Dates

  • Thread starter Thread starter Lyndie
  • Start date Start date
L

Lyndie

I have a rather looooong list of dates (mm/dd/yy). In a
column beside it I want just month and year so I can, for
example, find all books sold in a month range. Can you
help?
 
NO need where rngA has your dates and rngB is a count of the sales
=sumproduct((year(rngA)=2004)*(month(rngA)=8)*(rngB))
to sum rngC if it had the price total for each date
=sumproduct((year(rngA)=2004)*(month(rngA)=8)*rngC)
 
You must log in or register to reply here.

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

date 2
Dates? 2
change DD/MM/YY to MM/DD/YY 6
Date without true value 5
Weird date format problem 2
Excel Dates 11
Problem in SUMIF Function 1
Change from mm/dd/yy to yy/mm> 3

Back
Top