you can do =TEXT(A1, "dddd, mmm dd")
Where A1 is your date, or you can custom format the cell for "dddd, mmm dd"
if you want to enter date in cell. Only thing is you will only get Oct-6
rather then Oct 6th

"Té" wrote:

Is there a way I can have the day of the week and the date, for example
Tuesday Oct. 6th.