Date Combaning Issue?

SHAHZADBABAR

New Member
Joined
Sep 14, 2014
Messages
12
Case Scenario,
Sr. No
Sr. NOdayMonthYear
5962014
1786122011
900952010

<tbody>
</tbody>
on the basis of this formula automatically search Sr. no in data & then combine the dates & result like this
Sr. Nodate
509-06-2014
17806-12-2011

<tbody>
</tbody>
 

Some videos you may like

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

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,311
Office Version
  1. 2010
Platform
  1. Windows
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,177
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top