• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Auto-Populate Day

I need to have the day automatically populate in this online spreadsheet. https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&authkey=COOO6JsO&hl=en#gid=0

Currently the time column already auto-populates when the UTC value in column C is entered.  I just need to expand that so that the day column will also populate with the correct three (3) letter day.  Mon, Tue, Wed, Thu, Fri, Sat, Sun.

Assistance is greatly appreciated.
0
rtod2
Asked:
rtod2
  • 5
  • 4
1 Solution
 
Raheman M. AbdulCommented:
try entering in day:
=CHOOSE(WEEKDAY(TODAY()),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
0
 
Raheman M. AbdulCommented:
SORRY   IGNORE MY EARLIER COMMENT

=CHOOSE(WEEKDAY(TODAY()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
0
 
rtod2Author Commented:
I'm having trouble with that.  Would you mind doing it in the sheet itself?
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.

 
Raheman M. AbdulCommented:
Yes  i did on the sheet   (name is Abdul Rahman)  on row 13
0
 
rtod2Author Commented:
They can't all be Sat.  How can I get it to happen throughout the column.
0
 
rtod2Author Commented:
See comment in D4 for greater clarity on what I am trying to accomplish.
0
 
Raheman M. AbdulCommented:
Can you give the example date please
0
 
rtod2Author Commented:
It would have to be based on the UTC value.
0
 
rtod2Author Commented:
Row 3 shows the starting point from which each UTC value is derived.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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