Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF criteria using date ranges? | Excel Worksheet Functions | |||
count based on multiple date criteria | Excel Worksheet Functions | |||
Countif for multiple criteria | Excel Worksheet Functions | |||
Countif w/ Criteria | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions |