Formula required

New Contributor

The last two digits of the student number indicate the year the student enrolled. In F4 create a formula that will put "20" followed by the last two digits of the Student ID, e.g. 2015. Copy the formula down for all the other students. What is the value of the check digit in S6?excel.PNG

5 Replies



You can try this formula. What is the expected result of the check digit in S6?

year of enrolment.JPG


Thank you. It worked

@E_D_D_Y As a variant:


Same question with regard to "the check digit in S6".

thanks. it worked.


I have used a recent Excel 365 function

= 2000 + TEXTAFTER(studentID,"/")

It should return the entire column as a dynamic range.