I can calculate a contact's age from their date of birth, but I would now like to calculate their school year.
In this country the new school year starts on April 2nd and the students' age on that date determines their school grade/year.
So firstly, I need to calculate their age on April 2nd of the current year.
I then need to link this to their school grade i.e. 'if age 13 on April 2nd of current year' automatically populates another field with 'Junior High School Grade 2'
Any help with formulas for Dynamics 365 would be appreciated.