Dates

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?
 
D

Don Guillett

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