Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-02-2018, 01:36 PM
Glitch Glitch is offline Concatenate to reference values with that are dates Windows 7 64bit Concatenate to reference values with that are dates Office 2016 for Mac
Novice
Concatenate to reference values with that are dates
 
Join Date: Jul 2018
Posts: 12
Glitch is on a distinguished road
Default 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.
Reply With Quote
 

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 to reference values with that are dates Concatenate b16 Excel 1 01-09-2017 04:51 PM
Concatenate to reference values with that are dates 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
Concatenate to reference values with that are dates Reference another workbook and return values from the same cell across multiple sheets/tabs lwls Excel Programming 5 11-08-2014 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft