I am getting an error asking if I am trying to type a formula, but I am not sure what the issue is
Condition 1: K74=Yes
Condition 2: J74 between two dates
I tried making it an ifs function but then I dont have enough arguments
I think the issue that there are 3 conditions not two and the solutions I found online focus on two conditions only.
I also tried putting the commas in different places and using semi colons.
You have to build two conditions for the between-check without joing them as text: