autocopy lowest date from other cells to another cell in the same worksheet

[RogerRangeRover]

HI,

If you have

A____________B________________F

1.11.2009_____2.12.2010_________28.1.2008


Which formula would auto copy the lowest date of these three (A1,B1,F1) to another cell?

THANK YOU

[:) Sixthsense :)]

Please attach a sample data for better understanding...

[Ghozi Alkatiri]

may be
=MIN(A1:F1)

[Ghozi Alkatiri]

may be
=MIN(A1:F1)

[RogerRangeRover]

Hi,

Sixthsense, in other words:

I have for example the date 1.11.2009 entered in A1, 2.12.2010 in B1 and 28.1.2008 in cell F1. In need a formula inserted in G1 which scans the lowest date in these three cells and then copies that lowest date to the cell G1.

[RogerRangeRover]

Hi Ghozi,

MIN(...;....;....) works brilliantly. Thanks!