I am trying to edit an already existing sheet and am tracking the completion of training and want to add the date. Current formula is =COUTIF(D2:AE2,"yes")/27. I want to be able to have the date the training was completed after the "yes" in the cells, but all dates will be different and there is a range of more than 3 years for some. I am not advanced in Excel so hopefully there is an easy way to make is calculate with "yes" and any date. Happy to rephrase or elaborate if this doesn't make sense. Any help is appreciated!