I have been tasked to calculate certain segment fields into a bar chart. One of the fields require me to calculate the total number of blank fields for each month. This would require me to compare the date file (which has date in it) to the date processed column (some which are blank).
For example, if the date file field has a date of 3/21/2021 in it and the date processed field is blank, then this needs to be counted for the month of March.
I attempted using the following formula, but it seems that the results are incorrect. Could someone take a look and see what I am missing.
=COUNTIFS({Accrue Funding/Enrollment File Tracking Range 1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {Accrue Funding/Enrollment File Tracking Range 3}, "")