Skip to main content

Posts

Showing posts from March, 2022

Age Calculation in Excel 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 Yea