Posted to microsoft.public.excel.programming

Rob

external usenet poster

Posts: 718

CountIF Question

Thank You Tom, That Worked Perfectly.

Rob

"Tom Ogilvy" wrote:

=COUNTIF(B:E,"=9/1/2006")-Countif(B:E,"=9/2/2006")

--
Regards,
Tom Ogilvy

"Rob" wrote:

How do I get a formula to return the amount of cells that have a specific date?

Here's something I tried
=COUNTIF(B:E,"9/1/2006")
also
=COUNTIF(B:E,NOW()-5)

I get a big zero as the result

Here's what's in the cells...
9/1/2006 9:11:15 AM

Thanks in Advance,
Rob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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 question	stokie123	Excel Worksheet Functions	5	May 5th 09 03:14 AM
COUNTIF question	Jock	Excel Worksheet Functions	15	March 14th 08 12:32 PM
=countif question	edju	Excel Discussion (Misc queries)	5	October 4th 06 11:45 PM
COUNTIF question	scott	Excel Discussion (Misc queries)	1	May 16th 06 06:42 PM
COUNTIF Question	zbert	Excel Worksheet Functions	2	October 31st 04 05:14 PM

All times are GMT +1. The time now is 09:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us