You may need to check your Microsoft Windows date format settings to make sure the date format is set as d/m/yyyy.
If you set as m/d/yyyy, then you have to change the arrangement in B8 as B5&"/"&B6&"/19"&B4.
Wednesday, August 22, 2012
Extract Birthdate from Malaysia IC No
You can extract the birthday from the Malaysian IC No using the formulas as shown below:
You may need to check your Microsoft Windows date format settings to make sure the date format is set as d/m/yyyy.
If you set as m/d/yyyy, then you have to change the arrangement in B8 as B5&"/"&B6&"/19"&B4.
You may need to check your Microsoft Windows date format settings to make sure the date format is set as d/m/yyyy.
If you set as m/d/yyyy, then you have to change the arrangement in B8 as B5&"/"&B6&"/19"&B4.
Subscribe to:
Post Comments (Atom)
I had been looking around the best blogs site and now I’m on the right place, pretty wonderful!! advance payday loan
ReplyDeletethis is the best, yearggggggh, finally im found how to get the birthday month from IC list.
ReplyDeleteTQ
Glad you found it and like it. Let me know of other functions you need.
DeleteHi, I have trouble for IC for those born on 2000 onwards
Delete