37'

User info

Welcome, Guest! Please login or register.

You are here » 37' » 职场技巧 » excel技巧 » 根据身份证号码提取年龄

根据身份证号码提取年龄

Page: 1

Posts 1 to 2 of 2

1

  • Posted by: 37
  • Administrator
  • Registered: 2023-01-20
  • Invites: 0
  • Posts: 1193
  • Respect: [+0/-0]
  • Positive: [+0/-0]
  • Total time:
    4 days 3 hours
  • Last visit:
    2025-06-02 05:39:31

假定身份证在B列B2栏，点击C2单元格，输入公式

=YEAR(TODAY())-MID(B2,7,4)

该公式的含义是指今年的年份减去身份证上7-10位上的对应年份，从而得到需要的年龄数据

0

2

  • Posted by: 37
  • Administrator
  • Registered: 2023-01-20
  • Invites: 0
  • Posts: 1193
  • Respect: [+0/-0]
  • Positive: [+0/-0]
  • Total time:
    4 days 3 hours
  • Last visit:
    2025-06-02 05:39:31

=DATEDIF(IF(LEN(D1)=18,DATE(MID(D1,7,4),MID(D1,11,2),MID(D1,13,2)),IF(LEN(D1)=15,DATE("19"&MID(D1,7,2),MID(D1,9,2),MID(D1,11,2)),"")),TODAY(),"Y")
计算十足年龄

0

Page: 1

You are here » 37' » 职场技巧 » excel技巧 » 根据身份证号码提取年龄