display month only

  • Thread starter Thread starter aditya
  • Start date Start date
A

aditya

in cell A1 data is of 10 digit whose last 6 digit is in the form of ddmmyy.
i want to display only month name in cell B1

e.g. A1 B1
ACSD280509 MAY
RESG120309 MARCH
 
=TEXT(DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2)),"MMM")

To convert that to date
=DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2))

If this post helps click Yes
 
=TEXT(DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2)),"MMM")

To convert that to date
=DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2))

If this post helps click Yes
 

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

date entry 20
date & month 6
date entry new 3
Display entire number in cell 3
Moving range? 6
Calculating weeks 1
Formula IF 1
week entry new 3

Back
Top