Skip to main content

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 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

 

Search Topics :

Sama Soyab, 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, Soyab Sama

 

Comments

Post a Comment

Popular posts from this blog

Microsoft Word 2010 Shortcut Key in Gujarati

Microsoft Word 2010 Shortcut key in Gujarati
16 comments
Read more

How to create YouTube channel and get approved monetization

 Creating a YouTube channel and getting approved for monetization involves several steps. Here's a step-by-step guide to help you through the process: 1. **Create a Google Account**: If you don't have one, sign up for a Google Account. This account will serve as the foundation for your YouTube channel. 2. **Sign in to YouTube**: Using your Google Account, sign in to YouTube (https://www.youtube.com). 3. **Create Your Channel**: Click on your profile picture (if you have one) or the "Create" button in the top right corner of the YouTube homepage. Select "Create a channel" and follow the prompts to create your YouTube channel. 4. **Channel Name and Description**: Choose a name for your channel that represents your content. Write a channel description that explains what your channel is about. 5. **Channel Art and Profile Picture**: Customize your channel by adding channel art (banner) and a profile picture that reflect your brand or content. 6. **Upload Content
Post a Comment
Read more

List of all option in tally prime with explanation

 As of my knowledge cutoff in September 2021, TallyPrime is the latest version of Tally software, and it introduced a more user-friendly interface and several new features. Here is a list of some of the main options available in TallyPrime along with brief explanations: 1. **Dashboard**:    - The Dashboard provides an overview of critical business information, such as cash and bank balances, outstanding receivables and payables, and stock summary. 2. **Accounting Vouchers**:    - Accounting Vouchers are used to record financial transactions, such as payments, receipts, sales, purchases, journal entries, etc. 3. **Inventory Vouchers**:    - Inventory Vouchers are used to manage stock-related transactions, including stock transfers, stock journals, manufacturing entries, and more. 4. **Banking**:    - This option allows you to manage bank-related transactions, including cheque printing, bank reconciliation, and payment transactions. 5. **Payroll**:    - The Payroll feature enables you to
Post a Comment
Read more