Ymandel·President·✭

Comments

  • I tried it but its coming up invalid Data Type. this is the formula im trying =COUNTIFS(OR({Discharged Date}, >(DATE(2023, 5, 26)), @cell = ""), OR({Date Activated}, <(DATE(2023, 6, 2)), @cell = ""), {Status}, OR(@cell = "ACTIVE", @cell = "DISCHARGED")) please let me know where im going wrong
    inOR Function Help Needed Comment byYmandel 06/29/23
  • So now this formula works well =COUNTIFS({Discharged Date}, >(DATE(2023, 5, 26)), {Date Activated}, <(DATE(2023, 6, 2)), {Status}, OR(@cell = "ACTIVE", @cell = "DISCHARGED")) However, i need to add in an OR function to the first 2 phrases. it should count if {discharged date} is greater thatn 5.26.23 or Blank, AND {Date…
    inCoiuntifs Formula Help Needed Comment byYmandel 06/28/23
  • Yes! it did. i added the @cell and its working well. thank you so much!
    inCoiuntifs Formula Help Needed Comment byYmandel 06/28/23
Default Avatar