Find Age in Excel formula 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 :

soyab sama, 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, by sama soyab

 

Comments

Post a Comment

Popular posts from this blog

Learn (Gujarati Typing) Terafont-Varun Keyboard Layout by Sama Soyab

Image
 For Gujarati Typing : (by Sama Soyab) Required : Terafont-Varun Font  After Successfully Installed Terafont Varun Open Any Text Editor or any program. Select Font Terafont-Varun -> Ok   Search Topics : Sama Soyab, Learn terafont varun, Learn terafont chandan, Learn terafont gujarati to english translation, Learn terafont varun keyboard, Learn terafont converter, Learn terafont varun zip, Learn terafont keyboard, Learn terafont kinnari, Learn terafont akash, Learn terafont aakash, Learn terafont akash ttf, Learn terafont aakash gujarati download, Learn terafont akash keyboard, Learn terafont akash download for windows 10, Learn terafont akash font download, Learn terafont arun, Learn terafont border, Learn terafont chandan keyboard, Learn terafont-chandan font, Learn tera font chandana, Learn convert terafont to shruti, Learn convert terafont varun to shruti, Learn terafont varun chart, Learn terafont download, Learn terafont download for windows 10, Learn terafont downlo
Read more

Loops Example in Python

 Sure! Here are some examples of loops in Python: **1. For Loop:** For loops are used to iterate over a sequence (list, tuple, string, etc.) and execute a block of code for each item in the sequence. Example 1 - Iterate over a list: ```python fruits = ["apple", "banana", "orange"] for fruit in fruits:     print(fruit) # Output: apple #         banana #         orange ``` Example 2 - Iterate over a string: ```python message = "Hello" for char in message:     print(char) # Output: H #         e #         l #         l #         o ``` **2. While Loop:** While loops continue to execute a block of code as long as the specified condition is True. Example 1 - Simple while loop: ```python count = 1 while count <= 5:     print(count)     count += 1 # Output: 1 #         2 #         3 #         4 #         5 ``` Example 2 - While loop with user input: ```python password = "" while password != "secret":     password = input("Ente
Read more

Tally Shortcut key and Video Tutorial Link by Sama Soyab (ACI BHUJ)

Image
  AALIYA COMPUTER INSTITUTE     Tally Shortcut key and Video Tutorial Link   Sr Short key Option Video Link     Opening Balance Click Here 1 F5 Payment (F12->Use Single Entry mode for payment Receipt Contra-> yes/No) Click Here 2 F6 Receipt (F12->Use Single Entry mode for payment Receipt Contra-> yes/No) Click Here 3 F9 Purchase (Ctrl + V :- Single/Double Entry)  Click Here 4 F8 Sales (Ctrl + V :- Single/Double Entry)   5 F4 Contra (F12->Use Single Entry mode for payment Receipt Contra-> yes/No) Click Here 6 F7 Journal (Only Double Entry) Click Here 7
Read more