Insert Date From Right Column

[Dmichaud61]

What's the formula to select the date in the right column date? I'm using Excel 2016. Thank you in advance.

Date1	Date2	Date3	Answer
1 Sep			1 Sep
	3 Sep		3 Sep
4 Sep	5 Sep	6 Sep	6 Sep

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	Date1	Date2	Date3	Answer
2	01-Sep			01-Sep
3		03-Sep		03-Sep
4	04-Sep	05-Sep	06-Sep	06-Sep
Main

Cell Formulas
Range	Formula
D2:D4	D2	=LOOKUP(2,1/(A2:C2<>""),A2:C2)

 

[Dmichaud61]

How about

Fluff.xlsm
	A	B	C	D
1	Date1	Date2	Date3	Answer
2	01-Sep			01-Sep
3		03-Sep		03-Sep
4	04-Sep	05-Sep	06-Sep	06-Sep
Main

Cell Formulas
Range	Formula
D2:D4	D2	=LOOKUP(2,1/(A2:C2<>""),A2:C2)

Thanks Fluff. It worked perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.