I have a column of dates formatted mm/dd/yyyy on one sheet. On a second sheet in the workbook I am trying to keep a running count of the number of times January, February, March, etc... are entered. I have this below and it seems to work except for January. I get a count of 751, all of the blank cells. If I type a date in January 751 reduces to 750. For February, March, etc. it works fine.
=SUMPRODUCT(--(MONTH(INDIRECT(AB18))=1))
AB18 is Papers!$C$4250:$C$5000 for the other sheet and cell range.
Thanks for any help!
Bookmarks