On Aug 21, 10:09*am, "Rick Rothstein \(MVP - VB\)"
wrote:
=DATE(B2,MONTH(A2),DAY(A2))

That is the same formula (except for the row) that I posted. I just tested
it when the "21-Aug" is Text and the formula still worked correctly
(apparently Excel converts it to a date due to its being called by a
function requiring a date argument)... so your second formula appears not to
be needed... it looks like this one formula works in both cases.

Rick

"John C" <johnc@stateofdenial wrote in message

...



Is your first column text? Or is it a date. If it is a date, then it
already
has a year, and you could use the following formula:
=DATE(B2,MONTH(A2),DAY(A2))
If it is text, and only has 21-Aug entered, AND assuming that any dates
are
entered with a number, followed immediately by a - (dash), followed
immediately by a 3 letter month abbreviation, you could use the following
formula:
=DATE(B2,TEXT(A2,"m"),LEFT(A2,FIND("-",A2)-1))

Hope this helps.

--
John C

" wrote:

I have two columns that I want to merge into one. *The first column is
as month day column 21-Aug and the second column is a year column, ie
2003. * Is there a way to merge the two together? *I have tried the
CONCATENATE and the merge functions without success. *I am a fairly
novice/infrequent user of Excel.

Thanks.- Hide quoted text -

- Show quoted text -

You guys are awesome, thanks for all of the help. It worked like a
charm!