Posted to microsoft.public.excel.worksheet.functions

Jock

external usenet poster

Posts: 440

COUNTIF with dates

Dates in a column are formatted thus: 18/06/2007.
How can I adapt the COUNTIF formula to look at these dates (going back to
1986) and report back on the year part?
Any ideas?
--
tia

Jock

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
CountIF with dates	Secret Squirrel	Excel Discussion (Misc queries)	13	November 15th 06 09:08 PM
using countif to add dates	jwmillzy	Excel Discussion (Misc queries)	2	June 2nd 06 06:27 PM
COUNTIF using Dates	WLMPilot	Excel Worksheet Functions	1	October 7th 05 12:51 AM
Countif using dates	Bugaglugs	Excel Worksheet Functions	11	August 23rd 05 05:16 PM
countif and dates	JAF	New Users to Excel	2	December 3rd 04 04:45 PM

All times are GMT +1. The time now is 04:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us