On Fri, 16 Oct 2009 22:12:50 -0400, "T. Valko"
wrote:

=left(text(a1,"dddd"),3)

This will do the same thing:

=TEXT(A1,"ddd")

"ddd" = short weekday name format: Mon, Tue, Wed, Thu, Fri, Sat, Sun

"dddd" = long weekday name format: Monday, Tuesday, Wednesday, etc.


My handling is similar.

All of my stuff is free to use any, all, or part of as desired.

There are some errors with some local sheet hyperlinks (I missed
those), but the workbook itself is pretty good overall.

Two, actually...

http://office.microsoft.com/en-us/te...CT101440991033

or

http://office.microsoft.com/en-us/te...CT101440991033