Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count number of years 2003 in a range of dates
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 |
#2
|
|||
|
|||
Stan,
The following will work, just not on a whole column =SUMPRODUCT((YEAR(A1:A1000)=2003)*1) HTH, Bernie MS Excel MVP "Stan Altshuller" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Stan Altshuller" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
count weekdays in a date range | Excel Worksheet Functions | |||
dates in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |