Counting dates but only for a certain year

M

menken.john

Hi,
I'm using Excel 2010 and I have approximately 500 rows of data. One of the columns contains dates in this format: 12/12/2013 3:28:13 PM.
How would I count only the dates that fall anywhere in 2011? Thank you.
 
M

mcascia

Hi,

I'm using Excel 2010 and I have approximately 500 rows of data. One of the columns contains dates in this format: 12/12/2013 3:28:13 PM.

How would I count only the dates that fall anywhere in 2011? Thank you.

try this: (the sum column is in E and the dates are in Col D in this example.
Not sure what you are counting, but this should give you a way to do it.
=SUMIFS($E$3:$E$503,$D$3:$D$503,">=12/31/10",$D$3:$D$368,"<=1/01/12")
mark
 
C

Claus Busch

Hi,

Am Tue, 11 Feb 2014 07:08:40 -0800 (PST) schrieb (e-mail address removed):
I'm using Excel 2010 and I have approximately 500 rows of data. One of the columns contains dates in this format: 12/12/2013 3:28:13 PM.
How would I count only the dates that fall anywhere in 2011?

try:
=SUMPRODUCT(N(YEAR(D1:D500)=2011))

Regards
Claus B.
 

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