Shopping Cart

Validating an SA ID Number

It’s 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! In this article we look at validating an SA ID number on and Excel spreadsheet.

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.

Download this handy Spreadsheet that will make validating an SA ID number an efficient and easy to do task without having to come up with the Formula!

If you found this useful, check out our range of online Microsoft Excel training courses, ideal for both beginners looking to learn the fundamentals, as well as more advanced users wanting to take their skills to the next level.

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks

This draw is closed. Keep checking back, for the next draw.