Excel Date formula problem in excel

PRW

Joined
Dec 31, 2007
Messages
1
Reaction score
0
Hello all, I am new to this site and forums, so please bear with me!

I am trying to create a formula from a row of connecting cells that will select the earliest date in the list or give an answer of "None" if there aren't any dates in the list.

eg.
13-Jun, 17-Feb, 22-Nov, 05-Oct, 01-Jun. The result should be 17-Feb.
13-Jun, None, None, 05-Oct, 01-Jun. The result should be 01-Jun.
None,None,None,None,None,None, The result should be "None".

Many thanks in advance with this problem

PRW
 
Back
Top