LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cmharri123
 
Posts: n/a
Default How do I get a count of dates within a range..?


I have a column with over a thousand different sale dates within it. I
am struggling to get a simple countif formula to give me a total of the
dates within a certain range. I.e. give me the total number of sales
between 01-May-2004 and 01-Jul-2005...

I'm sure this is a simple one... can anyone help..??!

Thanks in advance.


--
cmharri123
------------------------------------------------------------------------
cmharri123's Profile: http://www.excelforum.com/member.php...fo&userid=3221
View this thread: http://www.excelforum.com/showthread...hreadid=507163

 
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
Count Problem between dates Frick Excel Worksheet Functions 4 December 15th 05 05:02 PM
Count occurances in range of cells Ed Gregory Excel Worksheet Functions 1 September 7th 05 04:12 PM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
count date occurances in range of dates... Alex Excel Worksheet Functions 2 July 27th 05 04:15 PM
Count cells based on date range in another column [email protected] New Users to Excel 1 May 5th 05 08:11 PM


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