Need help with a function to chose the correct number out of 2 numbers in one cell based on criteria

[duusomething]

Hello,

I'm working on a spreadsheet that has a reference table with this information:

Part	Process	Employee	Date	Time	Size	Serial No:	Carton Weight
10366/10367	L23	MFG	06/24/14	9:58:26AM	6		435
10366/10367	L23	MFG	02/17/14	8:57:38PM	6		436

<tbody>
</tbody>

What I need help with is creating a formula to add into one of my existing vlookup formulas that will automatically select the part as being either 10366 or 10367 based on the date that it has. For example, if the date is prior to 02/20/14 I would need it to select the part as being 10366. If the date is after 02/20/14 I would need it to select the part as being 10367. Is there a formula that will allow me to do this without having to split up the text?

Thanks for your help!

Duusomething

 

[Excelaron]

Why not just something like this =IF(D2<2/20/14,10366,IF(D2>2/20/14,10367,""))

 

[WarPigl3t]

=if(d2<>"",if(d2<"2/20/14",10366,10367),"")

 

[Michael M]

Are the part numbers always 5 digits ??
If so, try

=IF(D2<2/20/14,LEFT(A2,5),IF(D2>2/20/14,RIGHT(A2,5),""))