LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default Counting or summing up a group of cells with dates as datas

Hi,

I am making a report of numbers of clients we have served by quarter.
Example, in column A, I have dates as to when the clients entered in or
enrolled to our program starting from July of the current year to June of
next year. Our first quarter is from July to September, 2nd is October to
December, and so on. I have a column in another worksheet for 1st qtr, 2nd
qtr, 3rd qtr, and 4rth qtr.

What formula should I have in my 1st qtr column, 2nd qtr column, 3rd qtr
column and 4th qtr column so I could get the number of clients entered or
enrolled?

Any help would be appreciated.
 
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 dates in cells chrspty Excel Worksheet Functions 2 August 11th 08 08:10 AM
Summing cells containing dates Laura Excel Worksheet Functions 4 May 9th 08 08:05 PM
counting cells containing certain ranges of dates JRD Excel Worksheet Functions 1 December 12th 07 08:55 AM
Summing (or counting) cells until there is a blank cell Box815 Excel Discussion (Misc queries) 3 November 17th 06 03:35 PM
Counting the number cells between two dates Dave Excel Discussion (Misc queries) 3 March 16th 05 02:30 PM


All times are GMT +1. The time now is 01:21 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"