Add text to date pulled from another sheet

All,
I'm trying to when pulling a date from another sheet, adding text to the value.

=("Week of: ")& DATA!L1

Which produces "week of: 45420"

Im guessing its a date format i cant seem to get right?


Thank you in advance

That is a date serial number (what all dates look like to Excel) which needs to be formatted... use the TEXT function to apply the date format of your choosing. For example...

=("Week of: ")&TEXT(DATA!L1,"dd mmm yyyy")

I figured it out