Converting Date of Birth to 'Term of Birth'

Is it possible to convert a students DoB into their term of birth (ToB).

I.e. a student has the DoB of 1/1/2001 which would mean their ToB would be 'Spring'

I suppose what I'm after is...
If a DoB falls into one of three groups
1/1/year to 30/4/year = 'Spring'
1/5/year to 31/8/year = 'Summer'
1/9/year to 31/12/year = 'Autumn'

The year of birth is irrelevant, it's the month which determines the 'term of birth' (Spring/Summer/Autumn).

Can Excel do this?

If A1 holds DOB then perhaps

B1: =LOOKUP(MONTH(A1),{1,5,9},{"Spring","Summer","Autumn"})

No problem and I'm glad you went off and found your own approach.

I would say that you don't need column C and you can alter your formula in E a tad such that it becomes:

Please Login or Register  to view this content.

Or using the aforementioned LOOKUP approach and using your month/season setup:

Please Login or Register  to view this content.

It strikes me you are happier with VLOOKUP so I would advise you stick with it I merely show the above as an alternative.