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

You can do it like this:

=TEXT(MIN(C3:C11),"mm/dd/yy")&" to "&TEXT(MAX(C3:C11),"mm/dd/yy")

Hope this helps.

Pete

On Dec 31, 1:20*am, ordnance1
wrote:
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

Hi,

Since you already have A1 and A2 results, enter the following in A5

=TEXT(A1,"m/d/yy")&" to "&TEXT(A2,"m/d/yy")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ordnance1" wrote:

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