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: 17
Default Count Date Entries Per Quarter

Hola fellow Excel Kings & Queens~

Please let me know if there is a way to do the following:
Count the number of entries per quarter of data listed in a column.

I've thought about setting a < of entries falling between set date
criteria, but unsure how to do this. Column is currently formatted in
mm-dd-yy. I don't understand enough about converting date info so that I
might get the infor I'm after, but I have a hunch that I might have to go
down that road. :-)

Equation can be seperated into 4 seperate equations to keep things
simplified, the data is just ongoing and the results get put into
graphs/charts.

Your help is 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
Conditional formatting on Current or previous Quarter entries Loadmaster Excel Discussion (Misc queries) 3 December 4th 08 02:41 AM
Count instances of text in date entries MilusC Excel Worksheet Functions 11 August 2nd 08 05:48 PM
Count of days in a quarter Mahesh Excel Discussion (Misc queries) 6 July 23rd 07 02:53 AM
Count/Sum data with date entries. KBW Excel Worksheet Functions 6 April 5th 06 07:32 PM
Count data entries and date problem Gef Excel Worksheet Functions 5 November 4th 04 02:30 PM


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