DATE when a student must exit IF statement

I am trying to create a spreadsheet that will say what year a student must exit school.  A student with disabilities must exit by the spring of the school year that they turn 21.  So I want a calculation to add one year if they turn 21 between August 25th and December 31st of any given year.  Or return the same year if they turn 21 in January through June 8th of any given year. 

I might be complicating this too much so feel free to give alternate suggestions.

 

By: Sandra

Leave a Reply

Your email address will not be published. Required fields are marked *