# Date Combaning Issue?

##### New Member
Case Scenario,
Sr. No
 Sr. NO day Month Year 5 9 6 2014 178 6 12 2011 900 9 5 2010

<tbody>
</tbody>
on the basis of this formula automatically search Sr. no in data & then combine the dates & result like this
 Sr. No date 5 09-06-2014 178 06-12-2011

<tbody>
</tbody>

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### Useful

##### Active Member
Hello!
try
=INDEX(DATE(\$D\$2:\$D\$4,\$C\$2:\$C\$4,\$B\$2:\$B\$4),MATCH(A7,\$A\$2:\$A\$4,0))
here
year_range-D\$2:\$D\$4
month_range-\$C\$2:\$C\$4
day_range-\$B\$2:\$B\$4
Sr. NO_range-\$A\$2:\$A\$4
criteria is-A7

##### New Member
Thanks sir, it is working awesomley.
Thanks again

#### Rick Rothstein

##### MrExcel MVP
Hello!
try
=INDEX(DATE(\$D\$2:\$D\$4,\$C\$2:\$C\$4,\$B\$2:\$B\$4),MATCH(A7,\$A\$2:\$A\$4,0))
here
year_range-D\$2:\$D\$4
month_range-\$C\$2:\$C\$4
day_range-\$B\$2:\$B\$4
Sr. NO_range-\$A\$2:\$A\$4
criteria is-A7

Interesting formula construction, but if the result is going in the same area as the data, say Column E, then it would be simpler to use this formula in E2 and copy it down...

=DATE(D2,C2,B2)

You could use a similar construction on a different sheet, provided the "Sr. NO" values were listed in the same order, just provide the sheet name reference in front of each cell reference. The only time I could see the construction you posted as being necessary if is if the "Sr. NO" values were being presented in part or out of order on that other sheet (or elsewhere on the same sheet).

Replies
5
Views
52
Replies
7
Views
82
Replies
11
Views
200
Replies
2
Views
43
Replies
8
Views
77