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