This will give you the standard 3-letter abbreviation for a weekday:

=TEXT(WEEKDAY(A2),"Ddd")
Results: "Sun,Mon,Tue,Wed,Thu,Fri,Sat"

You could truncate that to a 2-letter abbreviation like this:

=LEFT(TEXT(WEEKDAY(A3),"Ddd"),2)
Results: "Su,Mo,Tu,We,Th,Fr,Sa"

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc