CountIfs w/ Dates

[Robby19]

Good day experts!

I am trying to get a count of data that meets multiple conditions. I have gotten then formula down, but it doesn't really seem to work. Case in point, with the below formula my total count is 98, when there are only 58 records that meet all of the conditions.

Could you please review and see if I am doing something wrong.

=COUNTIFS(AviKick[PMOS],[@MOS],AviKick[Date Enlistment or Acceptance],">=10/1/2018",AviKick[Date Enlistment or Acceptance],"<=12/31/2018",AviKick[DCC],"KC")+COUNTIFS(AviKick[PMOS],[@MOS],AviKick[Date Enlistment or Acceptance],">=1/1/2019",AviKick[Date Enlistment or Acceptance],"<=9/30/2019",AviKick[DCC],"KC")

 

[Robby19]

I also tried this, which reports the exact same numbers.

PrevStart = 1 Oct 2018
PrevEnd = 30 Sep 2019

=COUNTIFS(AviKick[PMOS],[@MOS],AviKick[DCC],"KC",AviKick[Date Enlistment or Acceptance],">="&PrevStart,AviKick[Date Enlistment or Acceptance],"<="&PrevEnd)

 

[Robby19]

I found the issue. The formulas, both of them, are working perfectly fine. It was human error in the fact that I have duplicated data on the report.