Hi Hannes,

Am Tue, 19 Jul 2016 09:57:21 +0100 schrieb Hannes Basson:

I used the following function on the ID number:

3308170035186

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

Then I get the following: 17 Aug 1933

I want to sort the birthdays from JAN - DEC without taking
inconsideration the year of birth

copy the column with the formula and insert it on same place as values.
Then make a helper column with the formula (modify the references):
=MONTH(E15)*100+Day(E15) and sort your table by the helper column.


Regards
Claus B.
--
Windows10
Office 2016