or use the same code in the text function, e.g:

TEXT(A1,"Dddd Mmm dd yyyy")


wrote:
I hope you don't mean serial numbers (!) - format, cells

set the format to custom as

dddd mmm dd yyyy

Belinda wrote:
I need to display both the Day in text and the date in serial numbers. How do
I do that?