IF formula

Brass Contributor

Hello, I needed a formula that would reference one of 2 dates. so if column Q contains "Yes" then reference the date in column R, or if Column Q contains "No" then reference date in cell O. Thank you!



6 Replies


Perhaps this one (You can change out the "-" with any desired text to show if the cell is neither "yes" or "no":


it references "1/0/1900" when I did the formula. @Patrick2788


This is my sheet:



Actually it worked, I had wrong cell referenced. thank you again!


Using named ranges

= IF(symptomatic="Yes", onsetDate, episodeDate)

or, borrowing from Patrick,
= SWITCH(symptomatic, 
      "Yes", onsetDate, 
      "No",  episodeDate, 


You're welcome!