Solved

Day needed in spreadsheet

Posted on 2011-03-19
7
365 Views
Last Modified: 2012-06-21
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
Comment
Question by:rtod2
  • 5
  • 2
7 Comments
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35173890
Still looking at how displaying the day but the times without a Name will not be displayed now.

Curt
0
 

Author Comment

by:rtod2
ID: 35173911
Great stuff !!
0
 

Author Comment

by:rtod2
ID: 35173947
Still having trouble with this one....
0
Technology Partners: 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!

 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 500 total points
ID: 35173955
Enter
=if(A2="","",mid(text(now()+$B2/24+5/24,"'Weekday 'EEEE"),8,10))
in C2
and copy down

Cheers,
Curt
0
 

Author Comment

by:rtod2
ID: 35173959
You mean copy down or use fill handle?
0
 

Author Closing Comment

by:rtod2
ID: 35173960
Outstanding!  A+++
0
 

Author Comment

by:rtod2
ID: 35173978
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question