Hey, it is a very simple formula presented by Mr. Hamid Ali Shah, UDC F.G. School Rawalpindi. You can easily find out your age by putting your date of birth and the present date. As there is requirement of Date of Birth as well as the Age in the vacancies recently announced by the FGEIs (C/G), so for this need this is simple formula that will be helpful for you.
Method to Find the Age
Open MS Office Excel Sheet.
Enter Your Date of Birth in Column “A”
Enter the required date or 03-12-2012 in column “B”
Copy the following formula and paste it into Column “C”
=DATEDIF(A1,B1,"Y") & " Years, " & DATEDIF(A1,B1,"YM") & " Months, " & DATEDIF(A1,B1,"MD") & " Days" After pasting the above formula press “Enter”. Your age is ready now.
If the formula does not work then
- Go to the Control Pannel of your system
- 2- Select Regional & Language Option
- 3- Click the “Date” Tab then 1st select “Day” then “Month” and at the last “Year”.
- 4- Then click “Apply”
Now all is done what you require to apply the accurate formula.
Don't Forget: Salary of a New Appointed Employee Scale Wise