Date to text conversion

MSD

New Member
Joined
Dec 22, 2005
Messages
1
I am stumped. How do I convert a mm/dd/yyyy date field to mmddyyyy and retain the 2 character month and date? I ahve broken the date apart into month, date, and year, but when I concatenate the fields, I can't retain the 2 place month and date. there must be an easier way.

Thanks,
Mark
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi, welcome to the board!

Is this what you want?

=TEXT(A1,"mm/dd")

where A1 contains your date
 

TeeMar

New Member
Joined
Oct 28, 2002
Messages
23
Just thought I'd post a Thank You ... it is over 8 years later and this answer "Keeps on Helping"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,083
Members
412,566
Latest member
TexasTony
Top