|
|
paymaster
new user
Reg'd: Thu
Posts: 3
|
|
How can I automatically show the 'day of the week' in a cell alongside the date in another cell. The date is in dd/mm/yyyy format
|
|
mgmcc
regular
Reg'd: Thu
Posts: 1105
Loc: Dundee, Scotland
|
|
If you have the date in A1, make B1 =A1 and format it as Custom dddd
If you want the day and date in the same cell, format it as
dddd dd/mm/yyyy
--------------------
-
Mike
|
The_Wanderer
regular
Reg'd: Mon
Posts: 424
|
|
Just to expound on what Mike says
From the Format menu select cells
From cells select custom
Then in the little window type dddd if you want the day of the week in full or ddd if you just want the first three letters. Likewise if you just wanted the month you could enter mmmm in that box or the first three letters of the month mmm.
|
|
|
Previous
Index
Next
Threaded
Edit
Reply
Quote
