How to Calculate Your Age in Excel with Video Tutorial by Sama Soyab

 

Open Microsoft Excel

-> Three Steps to Open MS Excel

1. Double Click on Ms Excel Icon

2. Start-> All Programs-> Microsoft Office -> Ms Excel

3. Start->Run-> Excel-> Ok

 => Give The Column Name in First ROW

Enter Detail Column A2,B2,C2 -> 

Find Year : =DATEDIF(D5,TODAY(),"Y")

DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date.

- D5 -> Is Cell Address where We entered Birth Date. 

- TODAY() -> This Excel Formula which shows current date.

- "Y" -> This is used for shows answer in Year

Find Month : =DATEDIF(D5,TODAY(),"Y")

DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date.

- D5 -> Is Cell Address where We entered Birth Date. 

- TODAY() -> This Excel Formula which shows current date.

- "YM" -> This is used for shows answer in Year + Month

Find Day : =DATEDIF(D5,TODAY(),"MD")

DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date.

- D5 -> Is Cell Address where We entered Birth Date. 

- TODAY() -> This Excel Formula which shows current date.

- "MD" -> This is used for shows answer in Month + Day

Find Total Month : =DATEDIF(D5,TODAY(),"M")

DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date.

- D5 -> Is Cell Address where We entered Birth Date. 

- TODAY() -> This Excel Formula which shows current date.

- "M" -> This is used for shows answer in Total Month

Find Total Day : =DATEDIF(D5,TODAY(),"D")

DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date.

- D5 -> Is Cell Address where We entered Birth Date. 

- TODAY() -> This Excel Formula which shows current date.

- "D" -> This is used for shows answer in Total Month

For Video Tutorial

Search Topics :

can you calculate age in excel, can you calculate age in excel from dob, how can we calculate age in excel, can you convert dob to age in excel, can you convert a date to age in excel, how can i get the age in excel, how to do age in excel, how to do age grouping in excel, how to do age analysis in excel, how do i calculate age in excel without datedif, how do you determine age in excel, how to do age distribution in excel, how to do average age in excel, how to do age bands in excel, how calculate age in excel, how calculate age in excel with date of birth, how to calculate age in excel between two dates, how to calculate age in excel from a specific date, how to group age in excel, how to figure age in excel, how to sort age in excel, age is excel, who to calculate age in excel, how to find age computer, how to find age of computer windows 10, how to find age of apple computer, how to find age of dell computer, how to find age of hp computer, where to find age of computer,