Solved

Day needed in spreadsheet

Posted on 2011-03-19
7
362 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

839 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