Stan Altshuller

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 Trashes Imported Dates	KymY	Excel Discussion (Misc queries)	3	April 27th 05 02:34 PM
how to increase maximum number of columns in excel 2003	[email protected]	Excel Discussion (Misc queries)	1	January 16th 05 08:13 PM
count weekdays in a date range	benb	Excel Worksheet Functions	1	January 13th 05 02:49 PM
dates in Excel 2003	[email protected]	Excel Discussion (Misc queries)	3	January 4th 05 11:04 PM
How do I display months and years between two dates	JSmith	Excel Discussion (Misc queries)	1	November 30th 04 04:41 PM

All times are GMT +1. The time now is 01:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us