Determine day of the week from date
 

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.

Determine day of the week from date
 

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

"Dan" wrote:

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.

Determine day of the week from date
 

=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


with @tiscali.co.uk


"Dan" wrote in message
...
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.

Determine day of the week from date
 

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

"Dan" wrote:

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.

Determine day of the week from date
 

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.


"Dan" wrote:

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.