Forum Discussion

LennyMed's avatar
LennyMed
Occasional Reader
Sep 24, 2025

Formula to calculate year of study

Can anyone help me, I think I need to use the "datedif" function but not sure. I have a column "year of study" and the course has a start and end date but I need to know their current year of study and not how long the course is. Thank you.

excel
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Sep 25, 2025

    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.

Resources