Hello Callan,

The easiest way is create a custom cell format.

1) Select the Cells or Cell you want to display the day of the week

2) On the Main Toolbar click Format

3) Click Cells...

4) Select the Number Tab

5) Click on Custom in the Category list

6) In the Type box (on the right) clear the contents

7) Type in ddd if you want to return the short form of the day (Sun
Mon, etc.)

8) Type in dddd if you want the full name of the day

9) Click OK

You can then reuse this format at anytime, anywhere in your workbook.


Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47615