Posted to microsoft.public.excel.worksheet.functions

Cassidy1

external usenet poster

Posts: 8

countif function using dates

It worked! Thanks very much Pete.

"Pete_UK" wrote:

Try it this way:

=COUNTIF(M3:M158,"30/09/2007")- COUNTIF(M3:M158,"=01/11/2007")

Hope this helps.

Pete

On Oct 12, 10:20 pm, Cassidy1
wrote:
I want to calculate the number of entries in a column that are later than one
date and earlier than another.
This is what I thought would work, but doesn't:
=COUNTIF(M3:M158,"30/09/2007"&"<01/11/2007")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Countif Function for dates in a range	Mbanker	Excel Worksheet Functions	2	August 22nd 07 11:21 PM
A week of dates and counting them using the COUNTIF function with contingencies	j razz	Excel Worksheet Functions	8	March 22nd 07 12:19 AM
CountIF with dates	Secret Squirrel	Excel Discussion (Misc queries)	13	November 15th 06 09:08 PM
Need help on countif and sumif function with dates and wildcard characters	chinita_jill	Excel Discussion (Misc queries)	5	July 19th 06 05:22 PM
COUNTIF using Dates	WLMPilot	Excel Worksheet Functions	1	October 7th 05 12:51 AM

All times are GMT +1. The time now is 06:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us