Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-11-06
3
Medium Priority
?
621 Views
Last Modified: 2013-11-06
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!
0
Comment
Question by:jalant
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
gowflow earned 1000 total points
ID: 39628008
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
 
LVL 31

Assisted Solution

by:gowflow
gowflow earned 1000 total points
ID: 39628013
here is a sample MMDD
gowflow
DatesMMDD.xls
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 1000 total points
ID: 39628016
=TEXT(A1,"mmdd")

or simply

=A1

and custom format it as mmdd
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question