Merging Date Columns
On Aug 21, 9:57*am, John C <johnc@stateofdenial wrote:
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 -
Thanks, you guys are great!
|