Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting dates in cells | Excel Worksheet Functions | |||
Summing cells containing dates | Excel Worksheet Functions | |||
counting cells containing certain ranges of dates | Excel Worksheet Functions | |||
Summing (or counting) cells until there is a blank cell | Excel Discussion (Misc queries) | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) |