Help with Spreadsheet model

[ThatOtherGuy95]

Hello everyone

 

im in the process off making a spreadsheet which is part of my first assignment in university (UK) and i have got a few questions that i was wondering if you guys would have any advice trying to solve, will do my best to explain them and will attach the files if i can

 

1) i have this set of dates that each fall between a certain season, i have created a function so that when you type in a date it will return what season its in but dont think its very efficient, has anyone got a better soluction to this. my function i wrote is under the photo

 

 

 

 

function:

=IF(AND(C18>=C13,C18<=D13),C12,IF(AND(C18>=C14,C18<=D14),C12,IF(AND(C18>=C15,C18<=D15),C12,IF(AND(C18>=E13,C18<=F13),E12,IF(AND(C18>=E14,C18<=F14),E12,IF(AND(C18>=E15,C18<=F15),E12,IF(AND(C18>=G13,C18<=H13),G12,IF(AND(C18>=G14,C18<=H14),G12,IF(AND(C18>=G15,C18<=H15),G12,"ERROR")))))))))

 

i then need to work out how to use the season information for each pricing as it changes depending, any help would be great.

 

cheers