Hi I am using the formula:
=COUNTIF($J$12:$J$3081,">="&DATE($T$2,IN1,1))-COUNTIF($J$12:$J$3081,">="&DATE($T$2,IN1,31))
To count the number of times dates appearing in a certain month appear in the J column. However this is not picking up dates which are on the 31st, I've included >= so not sure why this is happening.
Bookmarks