ExcelBanter - Eariliest data and time

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Eariliest data and time (https://www.excelbanter.com/new-users-excel/453578-eariliest-data-time.html)

Eariliest data and time

What formula will identify the cell that contains the earliest date and time?

Here is a sample of my spreadsheet:

B2 contains: 2015:12:25 14:01:38
C2 contains: 2016:04:23 06:49:44
D2 contains: 2016:04:23 06:49:44
E2 contains: 2015:12:25 14:43:31
F2 contains: 2015:12:25 14:43:31
G2 contains: 2015:12:25 14:43:31

Note: One to four of the cells in each row may be empty

[email protected]

Eariliest data and time

The data is the EXIF data in .jpg and .png files.

The columns are, respectively:

FileModifyDate
FileAccessDate
FileCreateDate
ModifyDate
DateTimeOriginal
CreateDate

All times are GMT +1. The time now is 03:53 AM.