Thread: Counting Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Solesbury[_2_] Mark Solesbury[_2_] is offline
external usenet poster
 
Posts: 1
Default Counting Dates

I have a column with lots of dates in.

I want a formula to count the number of dates, ie jan 2006 = 12

Any ideas,
Ive tried CountIf, and 2006 but i think the date formatting is messing
with it.


--
Mark

http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox