Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine next Saturday based on a given date | Excel Worksheet Functions | |||
report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
How can I convert a date into a week number... | Excel Worksheet Functions |