Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

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.
0
rtod2
Asked:
rtod2
  • 5
  • 2
1 Solution
 
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
 
rtod2Author Commented:
Still having trouble with this one....
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Cheers,
Curt
0
 
rtod2Author Commented:
You mean copy down or use fill handle?
0
 
rtod2Author Commented:
Outstanding!  A+++
0
 
rtod2Author Commented:
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now