Select date based on comdition

Excel 2007.  Column R11, S11, & T11 contain 3 different dates, in dd/mm/yyyy format.

R11  13-01-2019; S11  22-12-2018 and T11  15-12-2018.    Column U11 contains  1.

V11 should display the date in R11 if U11 is 1.

V11 should display the date in S11 if U11 is 2.

V11 should display the date in T11 if U11 is 3.

Precisely V11, based on the Condition in U11, displays the date either in R11 or S11 or T11.

Request a formula to achieve this in V11.

By: Muthukrishnan V

Leave a Reply

Your email address will not be published. Required fields are marked *