How to best convert Excel date to MMDD in another cell?

I currently have an Excel document with a column of dates. I need to end up with a new column that has the date (only month and day) in 4 digits, and must include leading 0s. I'm able to extract the day and month in separate columns using the relevant functions (day/month) and can add the leading 0 by changing the format.

However, when I attempt to concatenate the two fields, the leading 0s drop out. Is there any way to accomplish what I need?

Thanks!
jalantAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
if your date is in A1 then put this in B1
=TEXT(MONTH(A1),"00") & TEXT(DAY(A1),"00")

and drag downward. if you need ddmm just use this
=TEXT(DAY(A1),"00") & TEXT(MONTH(A1),"00")

gowflow
0
 
gowflowConnect With a Mentor Commented:
here is a sample MMDD
gowflow
DatesMMDD.xls
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=TEXT(A1,"mmdd")

or simply

=A1

and custom format it as mmdd
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.