Skip to main content

Posts

Showing posts with the label Calculate Your Age and Day of Birth in Excel

Calculate Your Age and Day of Birth in Excel

Sometimes, a person needs the exact age calculation from his / her date of birth to a specific date, for example when he / she applies for a job. The employer demands the required age must not be more that 21 years on the given last date for submitting job application. Calculate your age from your date of birth in MS Excel with Datedif() function             In such situation,  we need to calculate exact date in years, months and days. Because the difference of  a single day will also be considered.            Today, we will learn, how to prepare Microsoft Excel Worksheet for calculating Age in Years, Months and Days with the help of formulas and functions provided in MS Excel. We will also find and display the actual day of birth from the given date of birth for a person. Age Calculator Designed in Microsoft Excel Using DATEDIF Function Preparation Of MS Excel Worksheet To Tell your Age from Date of Birth First of all, start Microsoft Excel. Open a new blank workbook i