Formatting a date in a text concatenation where the date is grabbed from a different cell.

Cell B7 contains the date June 30.  Column B is hidden.  In cell C1 I want it to display "As of " & and then the date, but if you concatenate then the date is not in date format.  I know how to do th...