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: 6
Default Counting Occurences Between Dates

Hi All:

I have data that contains a variety of dates that I have sorted by date. I
am trying to count the nuber of occurences in a given month. EI:

Customer x 1/1/07
Customer x 1/1/07
Customer x 1/4/07
Customer x 1/5/07
Curtomer x 1/31/07

Total occurences for this customer would equal 5.
I have been trying Countif function but it is not returning any value other
than 0 or 1, so I believe that I am missing a step. I have looked through
some of the previous posts but did not see anything that may pertain to what
I am looking for. Thank you in advance for any advice you may offer.

Blddrgn

 
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 occurences of a name [email protected] Excel Worksheet Functions 3 October 8th 07 12:52 AM
Counting the occurences riomarde Excel Worksheet Functions 1 March 27th 06 09:00 PM
Counting Occurences Pete Excel Discussion (Misc queries) 7 May 2nd 05 08:28 PM
Counting occurences of a specific day between two dates coal_miner Excel Worksheet Functions 1 April 20th 05 03:37 PM
Counting Number of Occurences Darren Excel Discussion (Misc queries) 1 February 23rd 05 03:26 PM


All times are GMT +1. The time now is 05:36 AM.

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"