Counting cells in a selectable date range

roxley · roxley's Computer Specifications

Hello,

I am having trouble creating a formula that counts the number of cells that say "Y" in a range of dates specified by the user. The worksheet is set up as follows:
-The range of dates are A2:A27 with the associated cells with either "Y" or "N" in cells E2:E27
-The start date of the range is found in A1 and end date of the range is found in A2

Currently I'm using =COUNTIFS(E2:E27, "Y", A2:A27, "<=A1", A2:A27, ">=A2") which keeps returning 0, however, if I were to manually type the dates that wants to be searched (i.e. =COUNTIFS(E2:E27, "Y", A2:A27, "<=25/08/2010", A2:A27, ">=15/09/2010") it returns the correct number of times "Y" occurred in the date range.

Any help is appreciated.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting of a date from a range of Cells	Manikandan	Microsoft Excel Misc	2	29th Oct 2009 08:06 AM
counting cells that fall within a certain date range	MR. NICE	Microsoft Excel Misc	9	16th Jul 2008 06:15 PM
counting cells that are >0 in a range of non-contiguous cells	=?Utf-8?B?TWFyaw==?=	Microsoft Excel Worksheet Functions	9	14th Mar 2007 02:45 PM
Counting empty cells within a range of cells	Rosehill - ExcelForums.com	Microsoft Excel New Users	2	2nd May 2005 08:53 AM
Counting empty cells within a range of cells	Rosehill - ExcelForums.com	Microsoft Excel New Users	0	7th Apr 2005 12:47 AM