Good morning! I've got a spreadsheet with two tabs, where the "validation" tab displays summary information pulled from the "data" tab. I've got rolling data displaying counts from the current & previous 12 months which works, except for it does not seem to be counting entries from the last day of the month. The below is the formula that should return a count of closed items from the data tab which were closed in August 2021. The formula as below is returning "7," but the correct number is "8." I have verified that it is one entry on 8/31/21 in column O that is not being counted. I did make sure the column D condition is met. It may be something silly that I am missing. Any thoughts?
=COUNTIFS(Data!D:D,"=Closed",Data!$O:$O,">="&EOMONTH(TODAY(),-2)+1,Data!$O:$O,"<="&EOMONTH(TODAY(),-1))
=COUNTIFS(Data!D:D,"=Closed",Data!$O:$O,">="&EOMONTH(TODAY(),-2)+1,Data!$O:$O,"<="&EOMONTH(TODAY(),-1))