Determine day of the week from date

[Guest]

Each record in my SS has a date. I would like to determine the day of the
week from this date so I may chart the total number of records for each day;
Monday, Tuesday, etc.

 

[Guest]

Hi,

Couple of ways:

1 - format your dates as dddd
2 - use a formula like =WEEKDAY(A1) to give you the day in the form of a
number 1=Sunday, 7=Saturday
3 - use a formula to return day as text =TEXT(A1,"dddd")

HTH
Jean-Guy

 

[Sandy Mann]

=TEXT(G16,"dddd")

will return the day of the week for the date in G16

formatting cell G16 as custom format "dddd mmm d yyyy" (without the quotes)
will return "Wednesday Jan 31 2007" (again without the quotes) but the cell
will still hold onlt a number so to test for
=WEEKDAY(G16,2)=3

will return TRUE if the weekday is a Wednesday

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Thanks for the tip!
Just what I needed......

 

[Guest]

That's fairly easy. In the cell that you want the day of the week to show,
press your '+' key and use arrow keys to navigate to the cell that contains
the date, press Enter. Next, format the "Day" cell with 'Format Cells',
'Number', 'Custom'. In the Custom "Type" block type 'ddd' for a Wed type day
or 'dddd' for a Wednesday type day.