Work out Term of Birth by Date of Birth

**sezza79** · 09-18-2014, 10:09 AM

I have a spreadsheet of pupil data (in a school) and on it there is a column for date of birth and term of birth (e.g. Sum, Aut, Spr). Is there a formula to automatically populate the term of birth when entering the date of birth as follows:

Birth dates in Jan - Apr = Spring
Birth dates in May - Aug = Summer
Birth dates in Sept - Dec = Autumn

Thanks in advance!

**shg** · 09-18-2014, 10:18 AM

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

**sezza79** · 09-18-2014, 10:56 AM

Perfect! How to I leave the term of birth cell blank until the DOB is entered? Many thanks!

**daddylonglegs** · 09-18-2014, 11:06 AM

You can add an IF to shg's suggested formula, e.g.

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

Work out Term of Birth by Date of Birth

LinkBack

Thread Tools

Rate This Thread

Display

Work out Term of Birth by Date of Birth

Re: Work out Term of Birth by Date of Birth

Re: Work out Term of Birth by Date of Birth

Re: Work out Term of Birth by Date of Birth

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using a person's birth date to detect the originality of work performed on a sheet

Date of birth

Calculating Age from Date of birth

Converting Date of Birth to 'Term of Birth'

How do I work out people's exact ages from their Dates of Birth?

Bookmarks

Bookmarks

Posting Permissions