I am working on a project where i have to create a function that automatically updates student year (i.e. freshman, sophomore, junior, senior) based on number of years from the current year the person will graduate. i have made a nested IF function that does just that, however there is a problem. the school year starts in august and ends in may, so all students get their status updated on January 1st while the school year is not over. Is there anyway to make the year update on say June 1st so the student year doesn't change prior to when it is supposed to?
Here is the function i have written so far:
=IF(Z6-YEAR(TODAY())=1,"senior",IF(Z6-YEAR(TODAY())=2,"junior",IF(Z6-YEAR(TODAY())=3,"sophomore",IF(Z6-YEAR(TODAY())=4,"freshman",IF(2020-YEAR(TODAY())<=0,"alumni","unlisted")))))
Z6 is the cell that generates graduation year for incoming freshman. the function is set up to continue to update until after they graduate
Bookmarks