Excel extract date into cell

[Tony O]

I am using Excel 2007 for importing data from another program. Column
C always has the date in this form:
3/24/12

I would like a new column to show the following (without the quotes):
"Report for Saturday, March 24, 2012"

I tried this (but I am getting an error message):
="Report for " & date(c2)

Please advise.

 

[Don Guillett]

I am using Excel 2007 for importing data from another program. Column
C always has the date in this form:
3/24/12

I would like a new column to show the following (without the quotes):
"Report for Saturday, March 24, 2012"

I tried this (but I am getting an error message):
="Report for " & date(c2)

Please advise.

try
="report for" & text(c2,"mmm dd, yyyy")

 

[Ron Rosenfeld]

I am using Excel 2007 for importing data from another program. Column
C always has the date in this form:
3/24/12

I would like a new column to show the following (without the quotes):
"Report for Saturday, March 24, 2012"

I tried this (but I am getting an error message):
="Report for " & date(c2)

Please advise.

If you custom format the cell in the new column:

NewColumn: =C2
Format/Cells/Number Custom Type: "Report For " dddd, mmmm d, yyyy

This has the advantage of still being able to use the date in numeric formulas.