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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

I need an excel formula

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
wrt1mea
Asked:
wrt1mea
  • 2
2 Solutions
 
Dan CraciunIT ConsultantCommented:
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
 
jayakrishnabhCommented:
=TEXT(A1,"dd-mm-yyyy-")&TEXT(B1,"dd-mm-yyyy")
0
 
wrt1meaAuthor Commented:
PERFECT!
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now