I have a column filled with dates and am trying to count all the cells after a certain date, using COUNTIF(A:A,">"&DATE(xx,xx,xx)). The problem is it keeps including my column header ("Date") in its count. Why is this happening, and how can I fix it?
I think part of the problem may be that I'm using a cell reference for the date, so my actual formula is COUNTIF(A:A,">"&B1), where B1 contains a date in Excel format ("DATE(xx,xx,xx)"). I checked and I don't have this issue when I simply put a date into my original formula.
I have no clue what's going on and any help would be appreciated! Thanks!