IF formula

[jaolvera]

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!

[#2]

@jaolvera 

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

=SWITCH(Q2,"yes",R2,"no",O2,"-")

[#3]

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

[#4]

@jaolvera 

This is my sheet:

[#5]

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

[#6]

@jaolvera 

Using named ranges

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

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

[#7]

You're welcome!