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
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