Solved

I need an excel formula

Posted on 2014-03-21
4
163 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
ID: 39945331
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
ID: 39945340
=TEXT(A1,"dd-mm-yyyy-")&TEXT(B1,"dd-mm-yyyy")
0
 
LVL 1

Author Closing Comment

by:wrt1mea
ID: 39945368
PERFECT!
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39945403
Glad I could help!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

777 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