|
|
#1
08-02-2018, 01:36 PM
|
|||
|
|||
Concatenate to reference values with that are dates
I have a cell called A29 that gets its value from a the myfiled through a vba prompt when opening, I have the following cells below it that are just "=A29+1", "A29+2", resulting in a series of dates from A29 to A33. I would like to concatenate the dates in A29 & A33 to one cell, so that the result would look like : xx/xx/xxxx - xx/xx/xxxx Is this possible? I understand that the "/" is causing some issues. 
|
|
#2
08-02-2018, 03:53 PM
|
|||
|
|||
|
Maybe try...
=TEXT(A29,"MM/D/YYYY")&" - "&TEXT(A33,"MM/DD/YYYY")
|
|
#4
08-03-2018, 02:58 PM
|
|||
|
|||
|
Glad to hear it will help you. You're welcome!
|
|
| Tags |
| concatenate, date, ref fields |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| X axis graph all dates when date column contains specific dates..possible ? | DBenz | Excel | 2 | 03-28-2018 04:59 AM |
 Concatenate
|
b16 | Excel | 1 | 01-09-2017 04:51 PM |
|
Using Cell Values in Active Sheet to Populate Path to External Reference Link
|
wowcrofty | Excel | 4 | 12-19-2016 12:29 PM |
| Concatenate two textbox values for message box | Smithy02468 | Excel Programming | 1 | 11-08-2014 10:48 PM |
|
Reference another workbook and return values from the same cell across multiple sheets/tabs
|
lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
Windows 7 64bit 
Office 2016 for Mac
Linear Mode
