Solved

I need an excel formula

Posted on 2014-03-21
4
161 Views
Last Modified: 2014-03-21
See the attached sheet. All I am trying to do is combine two date fields, A1 & B1 into one cell with a dash in between. But when I do, the date returns as a number value.

A5 and A7 shows what I am trying to do with no luck.
Exp-Exch-3-21-14.xlsx
0
Comment
Question by:wrt1mea
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 400 total points
Comment Utility
You need to first convert your dates to strings. Put this in C1:
=TEXT(A1,"M/D/YYYY")&" - "&TEXT(B1,"M/D/YYYY")

HTH,
Dan
0
 
LVL 5

Assisted Solution

by:jayakrishnabh
jayakrishnabh earned 100 total points
Comment Utility
=TEXT(A1,"dd-mm-yyyy-")&TEXT(B1,"dd-mm-yyyy")
0
 
LVL 1

Author Closing Comment

by:wrt1mea
Comment Utility
PERFECT!
0
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
Glad I could help!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now