If statment looking up multiple cells with date values

[gill123]

I am not where to even start with this. Result I need a 4 digit year for figure out age for the equipment.
A2= Purchase date as Jul 15, 2001 12:00:00Am
B2= Install Date with same format as purchase date
C2 = Manufactured Year = yyyy as 1976
D2 = PO # as 73-4801 (first 2 digit represnt as year 1973)

I need to create if statement for results to be 4 digit year in seperate column. First if there is manufacture year then give me the year, if not then look at column install date and if there is date in column install date then give me the year (from the long date i only need 4 digit year), if there is no year in manufactured year or install date then lookin at purchase date and give me the year from that column, if none of the first 3 has information then look at PO # and give me the first too digits of PO number.

I Hope this makes sense. I am not sure where to begin creating this formula. I am really new to if statments so please help!

I have attached an 4 different senario's that i am facing.

Thank you
RG

[ChemistB]

Try something like this

=IF(F2>0,F2, IF(ISNUMBER(E2), YEAR(E2),IF(ISNUMBER(A2), YEAR(A2), IF(LEFT(G2,2)+0>14, 19&LEFT(G2,2), 20&LEFT(G2,2)))))+0

[Olly]

Your file doesn't match the column structure you give in your post.

Based on the attached file structure, try:

=IF(F2>0,F2,IF(E2>0,YEAR(E2),IF(A2>0,YEAR(A2),1900+LEFT(G2,2))))

[gill123]

Both the given formula above worked great for this. Thank you so much ChemistB & Olly. You guys were very quick. Thanks Again