Extracting the month that a date refers to in another cell

S

SVMIS

In cell A1 I have the date 3/15/2003 (no formatting).
In cell B1 I have the formula =year(A1). The year shows correctly as 2003.
In cell C1 I have the formula =text(weekday(A1),"ddd"). The text shows as
"Sat" which is correct.
In cell D1 I have the formula =month(A1) which correctly shows '3'. I
attempted to use =text(month(A1),"mmm") in cell D1, but it shows as "Jan".
Can someone tell me what I am doing wrong?

TIA, Alan
 
A

Aladin Akyurek

=TEXT(A1,"mmm") for 3-letter month name and
=TEXT(A1,"ddd") for 3-letter day name.

where A1 houses a true date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting month from a date field 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How To Have A Cell Be Blank If... 2
Return Month & Year of Date Value 1
date format 4
Last working day of a month 12
To show month end date from any date entered 7
Excel Add ^ to a row of cells containing letters 3

Top