Gregorian calendar 20 1906 month

You can use left and rigth to extract text for subtraction.

1. If only the year is calculated without considering the month, it is assumed that the data starts from cell A2.

Then the formula is as follows:

=year(today())-left(A2，4)

Fill down the formula as follows:

2. If you need to calculate the month, the formula is as follows:

=dateif(date(left(A2，4)，right(A2，2)， 1)，today()，“y”)

As shown in the figure below: