count number of years 2003 in a range of dates

  • Thread starter Stan Altshuller
  • Start date
S

Stan Altshuller

Hi All!

I have a column of dates in column A:A and want to count the number of dates
that have the year 2003 in them.
I am trying to use =countif(year(A:A),2003) but it does not want to take
that formula, it says there is a mistake in it.

Can anyone help?

Thanks so much!!

Stan
 
B

Bernie Deitrick

Stan,

The following will work, just not on a whole column

=SUMPRODUCT((YEAR(A1:A1000)=2003)*1)

HTH,
Bernie
MS Excel MVP
 
P

Paul B

Stan, here is one way,

=SUMPRODUCT((YEAR(A1:A100)=2003)+0)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

COUNT rows on external sheet if between date range 3
Count number of dates between a specified period of time 2
Excel Average dates help 0
count number of dates in a row of cel before or after a variable d 5
count number of dates in range 2
Excel Formula - Count Dates from another Sheet 8
Counting dates with specific criteria 1
Count IF 1

Top