Convert Date in Text to month and Year

E

Excellency

I am trying to convert text to month and year. In the cell it displays as
07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it
adds current year and displays something like 02/15/2010. Any idea what i am
doing wrong..

thanks
 
H

Héctor Miguel

hi, !

try to follow (and provide feed-back in) your previous post (???)

regards,
hector.
 
T

T. Valko

I may be over-complicating this, but that's what I do!!!

How to solve this depends on the possible year span of the dates.

If a date is 07/22 is that the date Jul 2022 or Jul 1922

Are the dates *always* in the year 2000 or greater?
 

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

Trying to convert mm/yy in text to Dec-07, it adds day & current y 12
Help with year to date comparison 4
find out specific month and year 1
Date 2
Date lists 3
Generating date from day, month year 4
Pivot Table showing wrong data 1
Convert Month, Week, Year to date 2

Top