Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Aug 23, 2023

IF Formula between dates

Hello I needed help with a formula, I need a count formula if the person is over the age of 65 (b2) and they have a 2nd bivalent booster (Bivalent Moderna or Bivalent Pfizer) that is dated after 4/1/2023. 

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 23, 2023

    jaolvera 

    =IFERROR(AND(B2>65,SMALL(IF((C2:K2="Bivalent Moderna")+(C2:K2="Pfizer Bivalent"),D2:L2),2)>DATE(2023,1,4)),FALSE)

    I'd use a helper column with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The results are then added with SUMIF.

     

Resources