how to return a date between two cells

[Michelle D via OfficeKB.com]

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

[pinmaster]

Something like:

=MIN(O1:P1)

HTH
JG