Find oldest date

[ianma]

Hi all,

I've got a spreadsheet that i want to find the oldest date someone has been looking after a vacancy for.

The cells where the data is being entered is in cells C13,C26,C39,C52,C65,C78 & C91

In cell C105 i would like the oldest date to be entered out of the above cells date.

So for example if C13 was 12.09.2008, C26 was 10.09.2008, C39 was 4.04.2009, C52 was 31.08.2007, C65 was 20.08.2009, C78 was 1.01.2009 & C91 was 1.09.2009.

I would like C105 to have C52 31.08.2007 entered in the cell

[NBVC]

Try

=Min(C13,C26,C39,C52,C65,C78,C91)

formatted as date.