Combine results of 2 formulas
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
|