Formula for picking date

[Muthukrishnan V]

MS Excel 2007. Columns G and J are "date" formatted, "dd/mm/yyyy.
In Column K the input is either 1 or 2. For example, if column K11 is "1",
L11 should display the date as in G11. If K11 is "2", L11 should display the
date in J11.

G J K L
11 10-05-2018 01-06-2018 1 10-05-2018
12 11-05-2018 02-06-2018 2 02-06-2018

Request formula to do this task.

 

[arthurbr]

Perhaps =CHOOSE(K11,L11,G11)

FWIW you have indicated 1 and 2 between double quotes? Are they text ? If so replace K11 with K11*1

 

[Muthukrishnan V]

I have simply entered either 1 or 2 in column K without quotes.

 

[Muthukrishnan V]

Sorry to disturb Mr Arthurbr. G11 date; J11 date; K11 1. (In Col K either 1 or 2). L11 result: If K11 1,
L11 will show the date as in G11. If K11 is 2, then L11 will show the date as in J11.

With above formula suggested in L11, I get Circular reference msg. Request help. I use MS Excel 2007. In K11,
I have entered number 1, in K12 2 , like that without quotes.

 

[arthurbr]

Ooops, sorry

=CHOOSE(K11,G11,J11) should do