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.
rtod2Asked:
Who is Participating?
 
Raheman M. AbdulConnect With a Mentor Senior Infrastructure Support Analyst & Systems DeveloperCommented:
SORRY   IGNORE MY EARLIER COMMENT

=CHOOSE(WEEKDAY(TODAY()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
try entering in day:
=CHOOSE(WEEKDAY(TODAY()),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
0
 
rtod2Author Commented:
I'm having trouble with that.  Would you mind doing it in the sheet itself?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
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. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
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
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.