how to return a date between two cells
 

I need help writing a formula that would choose two dates:

EX.

Column O Column P Column S

10/31/05 11/7/05 (need formula to return 10/31/05)

11/7/05 10/31/05 (need formula to return 10/31/05)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1

how to return a date between two cells
 

Something like:

=MIN(O1:P1)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498107