LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Counting dates


Trying to do something really simple here but cant seem to get it right


have a list of dates

12/01/2009
13/01/2009
12/01/2009
13/02/2009
14/01/2009


obviously the list is longer!

all i want to be able to do is count the number of entries for eg. jan

have tried =countif(A1:A5,"=**/01/2009")

but this just returns an error message

can anyone help prob dead simple if you know how!
thanks
wend




--
wendy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
counting different dates AJ Patel[_2_] Excel Worksheet Functions 4 August 13th 08 06:13 PM
counting occasions dates occur between 2 dates hoyt New Users to Excel 5 June 16th 06 08:11 AM
Counting dates, within a list of dates jrheinschm Excel Worksheet Functions 7 April 19th 06 06:13 PM
counting dates dayzee Excel Worksheet Functions 1 February 15th 06 10:20 AM
COUNTING DATES Cody Excel Discussion (Misc queries) 3 November 27th 05 03:51 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"