The formula is the formula "=DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"y")".

Lenovo GeekPro2020

Windows 10

WPS 2019

1. Age calculation.

1. Enter the formula "=YEAR(TODAY())-YEAR(B2)" in cell C2, press Enter, then double-click the lower right corner of the cell to fill it down or drag the right corner of the cell Fill the lower corners downward.

2. Enter the formula "=INT((TODAY()-B2)/365)" in cell D2, press Enter, then double-click the lower right corner of the cell to fill it down or drag the cell Fill the lower right corner downwards.

2. Calculation of virtual age.

Just add 1 to the one-year-old formula. Enter the formula "=INT((TODAY()-B2)/365) 1" or "=YEAR(TODAY())-YEAR(B2) 1" in cell E2, press Enter, and double-click the lower right corner of the cell to Fill it down or drag the lower right corner of the cell to fill it down.