Formatting a Date Cell Reference Within a String

[BarryC]

How do I format a date cell reference within a string? I want to put a
header on a page like "Report for 1/1/06 to 1/31/06". I tried ="Report
for " & namedrangeStart & " to " namedrangeEnd
That printed out "Report for 3817 to 38747". I tried the Format
function on the named ranges and it gives me a #NAME error.

 

[flummi]

start date in A1, end date in B1

In C1 enter:

="Report for
"&TEXT(MONTH(A1);"00")&"/"&TEXT(DAY(A1);"00")&"/"&TEXT(YEAR(A1);"00")&"/"&"
to
"&TEXT(MONTH(B1);"00")&"/"&TEXT(DAY(B1);"00")&"/"&TEXT(YEAR(B1);"00")

01/15/2005 06/30/2005 Report for 01/15/2005/ to 06/30/2005

Hans