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 |
All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com