#1
|
|||
|
|||
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
|
|||
|
|||
Maybe try...
=TEXT(A29,"MM/D/YYYY")&" - "&TEXT(A33,"MM/DD/YYYY") |
#3
|
|||
|
|||
Thank you! you are the man
|
#4
|
|||
|
|||
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 |