Formula to count # of dates per month in a date column
I am trying to create a formula that will tally, by month, the number of date entries in a column. (See screenshot attached).
Our non-profit provides ongoing financial counseling to veterans and each person is counseled more than once throughout the year...so I want to be able to tally each month how many new veterans we counsel by referencing the initial date column and then tallying above each month. This way a veteran counseled 4 times throughout the year is only counted once (as new in month X), and we can easily see how many new veterans we counseled by month and then roll up to a total sheet. In my screenshot example Jan # of Heroes would populate with 1, Feb 2, Mar 1 and so forth. I want the formula for each month to tell me how many dates in the initial date column fall within the date range of each month.
Please help! I thought I had it by looking at some other items in this forum but my formula did not work.
Help Article Resources
Check out the Formula Handbook template!