Combine data from 2 cells that have a date in them.

[Lorili]

I have a spreadsheet. I have attached the spreadsheet. I need to have Cabin creek sheet, A2,B2 and C2 combined in cell A2 in spreadsheet chart data. For example I need chart data, A2 to look like this:
12/11/09 to 01/09/09

[Andrew-R]

The formula you're looking for is probably:

=TEXT('Cabin Creek'!A2,"mm/dd/yy") & " to " & TEXT('Cabin Creek'!C2,"mm/dd/yy")

[Lorili]

Thank you Andrew!! That is exactly what I needed.