COUNTIF & Dates

jripp

New Member

Join Date: Jul 2010

Posts: 1

12th Jul 2010

Hi,

I am trying to develop a COUNTIF formula that will count the number of items in a range, base on a specific date, within a 10 day range after the specified date.

So if the specified date was 03/23/2010 I would want to count everything until April 3rd. I don't wnat to have to specify the end date I would rather have a formula that calculates the 10 day range from any given specified date.

Any help would be appreciated.

-Joe

« drop down box event changes in different cells | Cognos Certification Training Tools - Self Exam Engine »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with Dates	SRL	Microsoft Excel Worksheet Functions	3	27th Oct 2008 03:48 PM
Countif and dates	Tom	Microsoft Excel Worksheet Functions	4	14th Feb 2008 06:13 PM
COUNTIF using Dates	=?Utf-8?B?V0xNUGlsb3Q=?=	Microsoft Excel Worksheet Functions	1	7th Oct 2005 12:51 AM
Countif using dates	=?Utf-8?B?QnVnYWdsdWdz?=	Microsoft Excel Worksheet Functions	11	23rd Aug 2005 05:16 PM
countif and dates	JAF	Microsoft Excel New Users	2	3rd Dec 2004 04:45 PM