SUBSCRIBE FOR FREE EXCEL TIPS

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

January 28, 2020

Un-beknown to most, when you insert a new column, the Format of the cells in the Column are of the cells in the Column on the Left. So, if you get a Date when you enter a number as with the example shown, you would have inserted the column to the right of a Date Format...

January 16, 2020

A reminder of 2 very useful keyboard shortcuts!

Ctrl + ;                Current Date

Ctrl + shift + ;   Current time

These shortcuts will enter hardcoded values and will therefore not change on future days. If yo...

October 9, 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