Two Ridiculously Long Formulae - Can these be made less complicated ?

I have two very long formulas.

The first is in Cell N2 of my spreadsheet

PHP Code: 

=IF(A2="Six Day",(D2-TODAY())*(B8/365),IF(A2="Six Day 65 +",(D2-TODAY())*(B9/365),IF(A2="Six Day 70 +",(D2-TODAY())*(B10/365),IF(A2="Five Day",(D2-TODAY())*(B11/365),IF(A2="Three Day",(D2-TODAY())*(B12/365),IF(A2="Six Day 18 - 21",(D2-TODAY())*(B21/365),IF(A2="Six Day 22 - 24",(D2-TODAY())*(B22/365),IF(A2="Six Day 25 - 27",(D2-TODAY())*(B21/365),IF(A2="Six Day 28 - 30",(D2-TODAY())*(B20/365),IF(A2="Lady Six Day",(D2-TODAY())*(B15/365),IF(A2="Lady Six Day 65 - 69",(D2-TODAY())*(B13/365),IF(A2="Lady Six Day 70 +",(D2-TODAY())*(B14/365),IF(A2="Social",(D2-TODAY())*(B24/365),))))))))))))) 


The second in Cell S2 is:

PHP Code: 

=(IF(A2="Men Six Day",B8/365,IF(A2="Men Six Day 65 - 69",B9/365,IF(A2="Men Six Day 70 +",B10/365,IF(A2="Five Day",B11/365,IF(A2="Three Day",B12/365,IF(A2="Six Day 28 - 30",B20/365,IF(A2="Six Day 25 - 27",B21/365,IF(A2="Six Day 22 - 24",B22/365,IF(A2="Six Day 18 - 21",B23/365,IF(A2="Social",B24/365,)))))))))))+IF(F2="YES",B25/365)+IF(G2="YES",B26/365) 


Both of these work fine, but are long andpotentially open to errors.

I have restructured this spreadsheet already to match my Excel knowledge ability, but welcome any advice on making it simpler. If it possible, could any explanation be provided on how the revised formula would work.

Any other observations would be welcome. I've only just figured out Index/Match which I have used in C2

Thanks to you both. It will be tomorrow before I can try these out, but I'll come back to you then.

I wanted to acknowledge and let you know I hadn't left you without response.

I haven't figured out how to use VLookup yet. One more for the learning curve.

Originally Posted by HansDouwe

or in S2 please try:

=((F2="YES")*B25+(G2="YES")*B26+INDEX(B5:B26,MATCH(A2,A5:A26,0)))/365

Thanks very much. It works fine

Originally Posted by Glenn Kennedy

and S2 can become:

=(VLOOKUP(A2,$A$5:$B$26,2,FALSE)+IF(F2="Yes",B25,0)+IF(G2="Yes",B26,0))/365

Thanks for these two, they work great. In the end though I decided to go with Hans's solution. Simply because I understand how it works. I suspect VLOOKUP and INDEX/MATCH are very similar - the formula construction certainly is, but until I know that difference I'll use that one.