Selecting date based on column

[MN_Excel]

I have a spreadsheet in which I need to report the deposit date for transactions. However, the spreadsheet has separate columns to enter deposits dates. For example, cc deposit dates are entered in column A, check deposit dates are in column B, and EFT deposit dates in column C. For the purpose of my project, the type of deposit is irrelevant and I only need to report when the deposit was made. Any ideas on how to insert a column and have it bring in whatever date is in either column A, B, OR, C So, if there was a CC deposit date of 6/5/19, and the other two columns were blank, I want to bring in 6/5/19 in the newly created column? I'm not sure if I explained this well, but any help would be appreciated.

Thanks

 

[fhqwgads]

like this?

Book1
	A	B	C	D
1	cc	chk	eft	date
2	5/05/2019			05/05/19
3		20/05/2019		20/05/19
4			2/06/2019	02/06/19
Sheet39

Cell Formulas
Range	Formula
D2	=TEXT(A2&B2&C2,"dd/mm/yy")
D3	=TEXT(A3&B3&C3,"dd/mm/yy")
D4	=TEXT(A4&B4&C4,"dd/mm/yy")

this wont work if theres a line with 2 payments types

 

[fhqwgads]

using the MIN formula might be easier, plus it accounts for instances where there might be two dates in the same row, taking the earliest date

Book1
	A	B	C	D
1	cc	chk	eft	date
2	5/05/2019		10/06/2019	5/05/2019
3		20/05/2019		20/05/2019
4			2/06/2019	2/06/2019
Sheet39

Cell Formulas
Range	Formula
D2	=MIN(A2:C2)
D3	=MIN(A3:C3)
D4	=MIN(A4:C4)