Calculating the term from the date

Update: Since I recorded this method for calculating the term I have discovered a method that is responsive to the date of Easter in any given year. Watch the video below by all means, but read the next lecture before you implement in your school.

Term =
IF (
    MONTH ( 'Attendance Dates'[Date] ) <= 4,
    "Term 2",
    IF ( MONTH ( 'Attendance Dates'[Date] ) <= 8"Term 3""Term 1" )
)
Discussion

5 comments