How old is the owner of JMBG?

The unique identity number of citizens (JMBG) was created in the Socialist Federal Republic of Yugoslavia, and is still used today in the Republic of Serbia, for the purpose of identifying citizens. It is a mandatory datum in the identity card, driver’s license, health card, passport and all other important documents. Its first 9 digits indicate the date of birth. How to calculate the age of the JMBG holder based on this data?

Difference in dates

In one of the previous “recipes” you could find out how to calculate the number of past days between two dates. Excel has another function that can be used for this purpose. It is a hidden DATEDIF function, which, for two given dates, can calculate the number of years, months or days. The following text will be about how this function is used …