Is there a way of combining dates in various ranges like =CONCATENATE

**TonyTheOnly** · 11-15-2016, 02:38 PM

Hello,

Is there a way of combining dates in various ranges like =CONCATENATE; However with various group sizes / fields and a mass command? Attached is an image of what I am trying to do. Red is the range, Highlighted is the concatenate.

Thank you for any help
Capture.JPG

**mehmetcik** · 11-15-2016, 02:52 PM

You will get few responses with a request like that.

We need a spreadsheet to work on.

We also need before and after samples.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**dosydos** · 11-15-2016, 04:29 PM

Alright i included a spreadsheet with the formula that should work for you. It is located in the highlighted yellow cells. Of course when copying the cell over the first time you will need to change your reference points which i put in red. (ex. If putting this formula in F440 change both instances of F3=F439 and $B4=$B440

After this you should be able to copy and paste accordingly without having to change formula references.

=TEXT(OFFSET(F3,(COUNTIF($B:$B,LEFT($B4,5))*-1)+1,,),"mm/dd")&" - "&TEXT(F3,"mm/dd")