Date formula

[tannerdude]

I have a log sheet that I need the date to change to the days of the week.
The DATE formula just returns the date you enter. I want to be able to copy
this cell's formating and when I create more log sheets paste that formula in
the date cell and it will add a day or in the case of weekends or holidays
add how ever many to get to the next working day. Anyone know how to do this?

 

[edvwvw]

I have a log sheet that I need the date to change to the days of the week. 
The DATE formula just returns the date you enter.  I want to be able to copy
this cell's formating and when I create more log sheets paste that formulain
the date cell and it will add a day or in the case of weekends or holidays
add how ever many to get to the next working day.  Anyone know how to dothis?

To get the day of the week

=TEXT(A1,"Dddd")

edvwvw