=text(a1,"dddd")

But you could just format the cell with the date in it to show the date and day.

Give it a custom format like:

mm/dd/yyyy* dddd



TheRook wrote:

This is prob a simple one, but I am not thinking straight at this time of the
night.

I have cells populated with dates and want the day of the week in words to
automatically be populated in the next cell.

What formula do I use.

regards

--

Dave Peterson