If you've got a date in A2, then if in A1 you use
=TEXT(A2,"dddd") you'll get the text Wednesday
=TEXT(A2,"ddd") you'll get the text Wed
=A2 you can format the cell as ddd or dddd.
--
David Biddulph

shereea_1 wrote:
I have a worksheet and the headers are labeled with the days of the
week (Mon thru Fri) only. The next header row is labeled with the
month/day/year. The user set this up whereas just changing the
function would change the day of the week to match the date in the
row below it. How is this done?