Excel Tip - Verifying Personal Details using the SA ID Number

Its pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a few other Personal Details hidden within its 13 digits!

This is the breakdown {YYMMDD}{G}{SSS}{C}{A}{Z}

YYMMDD: Date of birth

G: Gender. 0-4 Female; 5-9 Male.

SSS: Sequence No. for DOB/G combination.

C: Citizenship. 0 SA; 1 Other.

A: Usually 8, or 9 (can be other values)

Z: Control digit.

Using this information and some neat Excel Formulas we can maximise the use of the ID Number to Verify and/or extract this key Personal Info, as well as validate the ID Number itself.

Click here to Download this handy Spreadsheet that will enable you to do all of that without having to come up with the Formula!

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Search By Tags

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions