SUBSCRIBE FOR FREE EXCEL TIPS

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...

As more and more Millennials creep into our Databases, it’s important that we beef up our Formula that extracts a Date of Birth from an ID Number to accommodate them.

With just a 2-digit year, the Excel Date function assumes the 1900s. As a result, the ID Number of some...

Have you ever had to extract a Date of Birth from an ID Number?

A client of ours once accidentally deleted all their respective Client Birthdays. They were incredibly relieved when they were introduced to the following Formula:

=DATE(LEFT(A2,2),MID(A2,3,2),MID(A2,5,2))

Si...

May 14, 2019

Anyone who has created an Excel Formula would have received an error stating that “There’s a problem with this formula”. Most of the time we spot the error straight away, fix it and our Formula is sorted. However, there are occasions that we simply cannot spot the mist...

May 10, 2019

Picking up from where the Key Essentials Course left off, the objective of this course is to expose one to the many powerful advanced functions that Excel has to offer, as well as cover some key principles that ensure good practice while avoiding common pitfalls when w...

Please reload

Please reload

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

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