cell data = "Schedule from " & A3 where A3 is a date.

[Peartree]

need to insert text and a date from another cell and have the date come back
other than the 5 digit number, ie 39574

 

[Mike H]

Maybe

= "Schedule from " & TEXT(A3,"DD/MM/YYYY")

Mike