Sorry, the formula in E3 should be:
=TEXT(WEEKDAY(D3,1),"dddd")
Thank you so much "JoeMo" you are the best.
Now that this is working - I'm exploring more options. Since this worksheet will have work days (Monday to Friday for the entire year) as shown in the example below.
My challenge to make this template is this. When a date is entered from 1/1/2013 so forth, how do you control the date since they are consecutive and you want to omit the weekends. (omit saturday and sunday).
Any suggestion would be appreciated. Thanks.
[TABLE="width: 96"]
<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
Tuesday[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"]
1/1/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Wednesday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/2/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Thursday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/3/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Friday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/4/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Saturday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/5/2013 omitted[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Sunday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/6/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Monday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/7/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Tuesday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/8/2013[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Wednesday[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]
1/9/2013[/TD]
[/TR]
</tbody>[/TABLE]