How to calculate the age of a person from its identity card number on excel.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
calculate age from identity card number
0
Answers
0
Need to extract values. if your string was in cell A1 then formula would be: =DATEDIF(DATE(MID(A1,6,2),MID(A1,4,2),MID(A1,2,2)),NOW(),"Y"). 1. convert string into date using Date formula. 2. use Datedif formula to take the difference between your date (from ID string) and compare it to Now.