Hello,
i'm trying to combine two dates with the word "to" in between (for ex: 09/15/2019 to 09/21/2019). I'm using the concatenate function.
I currently have:
In cell b1 = 9/15/2019
in cell b2 = to
in cell b3 = 9/21/2019
my formula looks like this: =concatenate(b$1," ",c$1," ",d$1)... This is what i'm getting 43723 to 43729. How do i convert the numbers to look like dates?
Thank you,
trish
1. You say the data is in B1 B2 B3 but then you say the formula is looking at B1 C1 D1 - you need to sort that out properly.
2. Dates are held in Excel as 5 digit numbers
You need to convert them to mm/dd/yyyy
Use
=concatenate(TEXT(b$1,"mm/dd/yyyy")," ",c$1," ",TEXT(d$1,"mm/dd/yyyy"))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you so much... That worked perfectly.
Would this work for you?
Enter formula in C1
=TEXT(B1,"mm/dd/yyy")&" to "&TEXT(C1,"mm/dd/yyy")
v B C D 1 9/15/2019 9/21/2019 09/15/2019 to 09/21/2019
Last edited by AlKey; 09-17-2019 at 07:05 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks