Counting dates but only for a certain year

[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.

 

[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

 

[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(D1500)=2011))

Regards
Claus B.