 |
Complete Age Calculate Formula |
Linkzwebsite presented Microsoft Excel Formula Tutorial and Tips.it is very simple instruction steps. Check your Complete Age Like this: (Years, Months, Days) now. This is a easy method to Find the Age.You can now search out your age by putting your date of birth and the to-date 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. DATEDIF Function is used for complete age (years, months, days).
Steps Create Formula:
- Open Ms Office Excel Sheet.
- Type "Date of Birth" Title in Column “A1”
- The required type "Current Date" in column “B1”
- Type Complete Age (Years, Months, Days) in column “C1”
- Enter Your Date of Birth in Column “A2”
- Enter to-day date or =today function in column “B2”
- Copy the following formula and paste it into Column “C2”
- =DATEDIF(A2,B2,”Y”) & ” Years, ” & DATEDIF(A2,B2,”YM”) & ” Months, ” & DATEDIF(A2,B2,”MD”) & ” Days”
- If you used Serial date them copy this function.
- =DATEDIF (A2, TODAY( ),"Y") & " Years, " & DATEDIF (A2, TODAY( ),"YM") & " Months, " & DATEDIF (A2, TODAY( ),"MD") & " Days"
- After pasting the above formula press “ENTER”.Your age is ready now.
Note:
If the formula does not work then- Go to the Control Panel of your system
- Select Regional & Language Option
- Click the “Date” Tab then 1st select “Day” then “Month” and at the last “Year”.
- Then click “Apply”
Now all is done what you require to apply the accurate formula.
Click on the image to enlarge it
+Formaula.jpg) |
Formula Step |
More Links:
Your waiting Online Services like Newspapers, TV Channels, Radio, Game.
Daily Live Gold and Silver Rates In Pakistan.
English Words, Phrases and Sentences Translate.
Today Cricket Match Watch Online On Live Cricket TV.
Ufone of All Call, SMS and Account Complete History Get it Details.