在Excel工作表A1单元格里存放了18位二代身份证号码,其中第7~10位表示出生年份。在A2单元格中利用公式计算该人的年龄,最优的操作方法是( )。
A. =YEAR(TODAY0)-MID(C19,6,8)
B. =YEAR(TODAY0)-MID(A1.6,4)
C. =YEAR(TODAY0)-MID(A1,7, 8)
D. =YEAR(TODAY0)-MID(A1, 7,4)
A. =YEAR(TODAY0)-MID(C19,6,8)
B. =YEAR(TODAY0)-MID(A1.6,4)
C. =YEAR(TODAY0)-MID(A1,7, 8)
D. =YEAR(TODAY0)-MID(A1, 7,4)
参考答案:D
参考解析:正在整理中,欢迎在文下评论区提供答案解析,谢谢!