Return Current Month
Hi I am trying to pull specific data from a Column when its end date field = current month.
I have gotten this far. =COUNTIF(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, IF(ASite:ASite, 1)) I am getting an incorrect argument error.
Here is what I am trying to do countif a cell in Column Asite is checked=1, and if the date in the cell of EndDate Column = the current month. Right now I was just using Nov or 11 instead of current month