Formula to calculate year of study

A “year of study” is basically: Current Year of Study = (Years since start) + 1

If your start date is in cell A2, you can use: =DATEDIF(A2, TODAY(), "y") + 1

If your institution considers the year change on a specific month (e.g. September), you can tweak it.

For example, if academic years start on September 1st, use:

=YEAR(TODAY()) - YEAR(A2) + IF(MONTH(TODAY())<9, -1, 0) + 1

If you also want to stop counting beyond the course’s official end date (say in B2), you can wrap it in MIN:  =DATEDIF(A2, MIN(TODAY(), B2), "y") + 1

That way, if today is beyond the end date, it just shows the final year.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.