Excel: text day of wk & day of Mth

Computing.Net > Forums > Office Software > Excel: text day of wk & day of Mth

Excel: text day of wk & day of Mth

Original Message

Name: woodcycl
Date: February 21, 2008 at 10:58:40 Pacific
Subject: Excel: text day of wk & day of Mth
OS: WinXP Pro
CPU/Ram: P4 2.6
Model/Manufacturer: custom

Comment:

What syntax would I use to obtain a view of a date field where it would show the text day of the week and then the day of the month?
For example, today is Thursday, February 21, 2008. I want the field to show: Thu 21
What syntax will result in Thu 21?
Many thanks,
Brian

Report Offensive Message For Removal

Response Number 1

Name: DerbyDad03
Date: February 21, 2008 at 12:04:37 Pacific
Subject: Excel: text day of wk & day of Mth

Reply: (edit)

To get Thu 21 use:
=TEXT(A1,"ddd") & " " & DAY(A1)
To get Thursday 21 use:
=TEXT(A1,"dddd") & " " & DAY(A1)

Report Offensive Follow Up For Removal

Response Number 2

Name: jon_k
Date: March 1, 2008 at 11:55:40 Pacific
Subject: Excel: text day of wk & day of Mth

Reply: (edit)

Just thought I'd add if you don't want pure text, but rather want to apply formatting to the cell itself (while keeping the date)
dddd dd
ddd dd
is the syntax you need

Report Offensive Follow Up For Removal


EXCEL (help) copy array of cells Excel: multiple imports/date range MOVING Excel info into Word Excel searching for multiple values MS Excel - Change text with IF	Excel Formula Help for Bill Trackin EXCEL: DAYS360 oh dear Running Total in Excel Excel forumula to add a month Give me a clue with Excel!

Creating Interactive PDF

error on archiving

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Excel: text day of wk & day of Mth

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Laptop Driver NEEDED

PHP 5 IIS 6 HTTP 401.3 error (REPLY

Monitor Settings Change by itself

Local Disk C: Problem

Desktop Not Occupying Entire Screen

All Posts Awaiting Replies