Is it possible to put the date into "January 7, 2005" style, or can I only do
it numerically?

"Dave O" wrote:

This will convert the 38359 to a date format in your formula:
=TEXT(A1,"mm/dd/yy")&" your cell reference here"