IF with dates and ignoring year

[jakefh]

Hello all.

I am writing a sheet to use in a school.

I have a column with (UK) date of birth for students in DD/MM/YYYY format.

I would like an additional column that says whether a student was born in Autumn Term (1st Sept to 31st Dec), Spring (1st Jan to 30th Apr) or Summer (1st May to 31st Aug) regardless of year of birth.

I've tried various combinations of IF formula with DATE & DATEVALUE to no avail.

Thanks.

 

[netuser]

Here you go with based on date in B1

Excel 2010 32 bit

	A	B
1	Autumn	2016-11-01

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Feuil30​

Worksheet Formulas Cell Formula A1 =IF(MONTH(B1)<5,"Spring",IF(MONTH(B1)<9,"Summer","Autumn")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[jakefh]

Thanks. Perfect.

Simple really - I blame my head cold

 

[netuser]

You are welcome, I am glad it helped