Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

Countif and date check for second criteria

Hi,

I have a sheet that needs to use countif to increment by 1 for a value
that falls btw 2 dates.

I have a column that needs to record the amount of times a date equals
or falls btw 2 dates.

So if I put 01/01 and 01/30 for dates I need countif secound argument
to be a compound like this

Countif(A1:A100, AND(""date(01/01) , "<" date(01/30)))

This is not working for me and my programming knowledge is not
extensive. Any help or direction would be appericated

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to 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 and date check for second criteria	[email protected]	Excel Worksheet Functions	0	November 29th 05 09:40 PM
COUNTIF criteria using date ranges?	Annie	Excel Worksheet Functions	3	August 26th 05 07:25 PM
count based on multiple date criteria	lisaw	Excel Worksheet Functions	1	August 9th 05 05:31 PM
Countif for multiple criteria	Jim Rennie	Excel Worksheet Functions	3	June 21st 05 01:38 AM
use a date range as criteria in a countif formula	mbparks	Excel Worksheet Functions	3	January 2nd 05 11:06 PM

All times are GMT +1. The time now is 05:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us