memory is eternal

life is a series feelings and sometimes thinking about these feelings.

memory is eternal!

No comments:

Post a Comment

Excel 身份证号码 自动计算年龄

在实际生活中,往往要根据身份证号码自动计算年龄,在Excel中,采用Excel2003YEAR函数获得当前年份,采用Excel2003MID函数取得身份证号码的出生年份,可快速地根据身份证号码自动计算年龄。 如图所示,在B2单元格输入身份证号码,在C2单元格输入: =YEAR...