how to Show dates as the day of the week?

[onlinetsn]

Now I have a problem how to convert dates to weekdays like Monday
Tuesday,and etc.

I have used Help function, it showed that:

Format cells to show dates as the day of the week

1.Select the cells that contain dates you want to show as the day o
the week.
2.On the *Format * menu, click Cells, and then click the Number tab.
3.Under *Category*, click *Custom*, and in the *Type box*, type ddd
for full weekdays (Monday, Tuesday, etc.), or ddd for abbreviation
(Mon, Tue, Wed, etc.). (What does it mean?)

I tried it for few hours, but...

Or is there any other functions?

So..can any one help me? I want to show the weekdays of whole column.

I used Excel 2002

th

 

[Frank Kabel]

Hi
where do you have problems with this explanation?.
1. Open the menu 'Format - Cells' and click on the left-most tab
('Number')
2.. Now you see on the lft hand side of this dialog a listbox with
various entries. cliuck on the last one ('Custom')
3. Now you see on the right side a textbox (pre-filled with something).
Just enter
DDDD
in this textbox and hit ENTER

 

[Arvi Laanemets]

Hi

Now I have a problem how to convert dates to weekdays like Monday,
Tuesday,and etc.

I have used Help function, it showed that:

Format cells to show dates as the day of the week

1.Select the cells that contain dates you want to show as the day of
the week.
2.On the *Format * menu, click Cells, and then click the Number tab.

Usually the Number tab is selected, unless you have formatted something
before and activated another tab during same session.

3.Under *Category*, click *Custom*, and in the *Type box*, type dddd
for full weekdays (Monday, Tuesday, etc.), or ddd for abbreviations
(Mon, Tue, Wed, etc.). (What does it mean?)

Exactly what you read!
On Format Cells window's Number tab is a list of categories
General
Number
Currency
....
Custom

Click on last selection in list - Custom. A Type textbox with list of
defined types below it is displayed right to category list. Type into
textbox the string 'dddd' and press OK. When entrie(s) in formatted cell(s)
were entered as valid dates, then they are now displayed as weekdays (p.e.
Monday).

I tried it for few hours, but...

How did you get your dates into cells? Are they dates at all? To check this,
p.e. with date in A1, enter into some free cell a formula
=DAY(A1)
or
=MONTH(A1)
or
=YEAR(A1)

When those functions do return a right day/month/year, then your date is OK.
Otherwise it was entered in non-valid format, or it is text.

NB! When your dates were datestring texts at start, the formatting them as
dates isn't enough. To convert datestrings to dates, format them as dates.
enter a number 1 into some free cell, formatted as general or number, copy
it, select the range with datestrings, select from Edit menu Paste Special,
check Multiply in Paste Special window, and press OK. (Maybe you need to
format your dates again then.)

Arvi Laanemets