Day needed in spreadsheet

I need a "day" calculated in this sheet >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en along with a description in sheet3 of the formula used for the other two columns.  Assistance is greatly appreciated.
rtod2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Curt LindstromConnect With a Mentor Commented:
Enter
=if(A2="","",mid(text(now()+$B2/24+5/24,"'Weekday 'EEEE"),8,10))
in C2
and copy down

Cheers,
Curt
0
 
Curt LindstromCommented:
Still looking at how displaying the day but the times without a Name will not be displayed now.

Curt
0
 
rtod2Author Commented:
Great stuff !!
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
rtod2Author Commented:
Still having trouble with this one....
0
 
rtod2Author Commented:
You mean copy down or use fill handle?
0
 
rtod2Author Commented:
Outstanding!  A+++
0
 
rtod2Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.