In cell A1 is the formula:

=MIN(C3:C11) 'Returns the earliest date

In cell A2 is the formula:

=MAX(C3:C11) 'Returns the latest date

What I need is a formula that I can put in cell A5 which returns something
like:

12/14/08 to 01/22/09