Forum Discussion
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/...
=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.