| paymaster |
| (new user) |
| Thu Jul 02 2009 07:28 AM |
Day of week in Excel
|
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) |
| Thu Jul 02 2009 08:20 AM |
|
Re: Day of week in Excel
|
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
| The_Wanderer |
| (regular) |
| Thu Aug 27 2009 01:09 PM |
|
Re: Day of week in Excel
|
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.