Calculate Your Age Using Excel

By

Have you ever thought that you can calculate your age with the help of Excel??

Well.. It is absolutely possible and Excel can calculate your age… but how?? Let’s learn through this blog post.

To calculate age, we can use DATEDIF function in excel. (We have already posted separate blog on this topic and if you want to learn in detail about DATEDIF function in excel, you can click here.)

For this we have to provide two inputs:

1. Date of Birth and
2. Today’s Date

In below image, we have entered first input i.e. Date of Birth in cells “A2” and second input i.e. Today’s Date in cell “B2”.


With the help of these two dates, we can:

1. Calculate the age in Years,
2. Calculate age in Years & Months
3. Calculate age in Years, Months & Days

Calculate Age in Years:

1. We want to calculate age in years in cells “C2”, so we have to select cell “C2”.


2. Enter below formula in cell “C2”
    =DATEDIF(A2,B2,"Y")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in years is now displayed in cell “C2”.



Calculate Age in Years and Months:

To calculate age in Years and Months we will use the same inputs as we have used in above steps. Also we have already calculated our age in years with the help of above steps, so in this section, we will only calculate the months.

1. We will calculate the completed months of our age in cells “D2”, so we have to select cell “D2”.


2. Enter below formula in cell “D2”
    =DATEDIF(A2,B2,"YM")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in Years and Months is now displayed in cell “D2”.



Calculate Age in Years, Months & Days:

To calculate age in Years, Months & Days, we will use the same inputs as we have used in above steps. Also we have already calculated our age in Years and Months in above steps, so in this section, we will only calculate the months.

1. We will calculate the completed Days of our age in cells “E2”, so we have to select cell “E2”.


2. Enter below formula in cell “E2”
    =DATEDIF(A2,B2,"MD")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in Years, Months & Days is now displayed in cell “E2”.


Thus, the age which we have calculated is “31 Years, 2 Months and 1 Day”. You can also try to calculate your age yourself and mention your queries in comments section.
Microsoft Certified Excel Expert, Enthusiastic to teach excel tricks and basic excel concepts which will help to save time and efforts in our daily office work.

Comments

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Excel Shortcuts Ctrl A to Ctrl Z

By
Image
Use of keyboard shortcuts while working in excel will be a great help for us. It will save a lot of time. In this post we are going to see Excel Keyboard Shortcuts for alphabets A to Z while using Ctrl key. Below table will give you a brief idea for each shortcut and its functionality: Now, we will see in detail how each of above listed shortcut combinations will work: Ctrl + A :  It will select all content present on the worksheet. If active cell is in the table then it will select entire table. Ctrl + B :  It will convert selected text into Bold . Ctrl + C : It will copy the selected content. The content which is copied can be seen in the Clipboard. Ctrl + D :  It will fill down the content from upper cell. For example we have inserted a number “1” in the cell A1. If we select the cell range from A1:A5 and press Ctrl + D, then this number “1” will automatically fill down in the entire cell range . ...
Read more

How to Remove Duplicate Entries from Multiple Columns in Excel

By
Image
In our last blog post, we have learned to remove duplicates entries in excel . In this blog post, we will go little advanced to remove the duplicate entries from multiple columns. Removing Duplicates Entries from 02 Columns: We will learn to remove duplicate entries from the data as shown in below image. The entries which are duplicate in both the “Fruits” column and “Price/Kg” column are highlighted with different colors. To remove duplicate entries in these 02 columns, follow the steps provided below: 1. Select the data from which we want to remove the duplicates. 2. Go to “Data” tab and under “Data Tools” we can find command named as “Remove Duplicates” as highlighted in below image. 3. Once we click on “Remove Duplicate” command, one dialog box with same name “Remove Duplicate” will appear on our excel screen. 4. If we check the checkbox for “My Data has headers” then the header row from our selection will be excluded automatically and under “Columns” section we will see the name o...
Read more

Excel Pivot Table

By
Image
Pivot Table in excel is a very powerful feature which helps us to to organize and summarize the data in very effective manner, that too without using any complex excel formula or functions. In this blog post we will see how to create Pivot Table in Excel. Below is the dummy sales data for last three years (2018, 2019 & 2020). In this sales data employees A, B, C & D sales various electronic components like Resistor, Capacitor, Inductor, Diodes & LED in all South, East, North & West region of India. Creating Pivot Table: Now we will see how to create Pivot Table in Excel. Pivot Table feature is available in Insert Tab. Pivot Table command is available in "Insert Tab" under "Tables Group" as shown in below image. Once you click on Pivot Table command, “Create Pivot Table” dialog box will appear on screen. This is like as shown in below image. This “Create Pivot Table” dialog box is very important to create Pivot Table. There are two important options a...
Read more

Select all cells highlighted with specific color at a time

By
Image
Many times we apply colors to cells in excel sheet which will help us to identify important cells just by looking at the data. But what if we use multiple colors to highlight data and later on want to select all the cells which are highlighted with specific color only???  YouTube Video: For example, we have listed some values in excel sheet and highlighted few cells with red color and few cells with yellow color. Now, we want to select all cells which are highlighted with only yellow color at a time. But how????  Don't worry... We will provide you a fantastic solution for this!! Follow below steps:  1. Select entire data. 2. Press Ctrl + F. "Find and Replace" window will appear. 3. Click on Options button. 4. "Find and Replace" window will expand with some additional options. Click on Format button. 5. "Find Format" window will appear. Click on Fill tab and select yellow color. You will s...
Read more

Merge data from Duplicate Rows into a Single Cell in Excel.

By
Image
In this blogpost, we will learn to merge data from duplicate rows into a single cell in excel. Many times, we may face a situation where we have duplicate entries in rows,  and we want to merge the data from these duplicate entries into single cell. This post is perfect solution for similar problems. Let us understand this solution with simple example. Let us assume that we have a supplier database in which we have multiple contacts listed for same supplier in multiple rows (as shown in below image). In this database, Supplier 1 with unique supplier code has 03 different Contact IDs listed in 03 different rows and same scenario is with Supplier 2, Supplier 3, Supplier 4 and Supplier 5. Now we want to merge these multiple Contacts IDs for respective supplier in a single cell separated by semicolon (;). To merge data from multiple rows into a single cell in excel, follow below simple steps: Before following the below steps make sure “Supplier Code” column is sorted (Sort Type is...
Read more

Title Bar in Excel

By
Image
Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post. Title Bar is divided in 03 parts: 1. Quick Access Toolbar 2. File Name 3. Minimize, Maximize/Restore, Close buttons Let’s see in detail about this. Quick Access Toolbar:  The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “ Format Painter ” as a desired command) 2. Select option “Add to Quick Access Toolbar”. 3. Now, you will see “ Format Painter ” command is added in the Quick Access Toolbar. 4. To remove desired command from Quick Access Toolbar, just right click on the command and then select option “Remove from Quick Access Toolbar”. 5. No...
Read more

Cell Address and Cell Range in Excel

By
Image
If you are following my blog regularly, then till now you might aware that Cell is an area of intersection of row and column. But do you know how many total cells available in a single excel worksheet?  In the very first topic which I have posted on this blog titled as “ Introduction to Excel ”, I have mentioned that there are 16,384 columns and 10,48,576 rows available in excel sheet. So if we multiply no of columns to the no of rows then we will get the total no of cells. i.e. 16,384 x 10,48,576 = 17,17,98,69,184 cells are available in a single excel sheet. Now, important point to be considered here is that how we will come to know that exactly on which cell we are working? To know this we should be aware of cell address of each cell. This cell address will define exactly on which position we are working. This will help us when we will use various formulas. (We will cover excel formulas in our subsequent blog posts. Stay tuned for this!!!). So let’s see what are the...
Read more

Bold, Italic and Underline Commands from Font Group

By
Image
Bold, Italic and Underline… These three commands are very basic but very important and frequently used in excel. These commands can be found under Font Group. YouTube Video: Let us have detailed description about these commands..!                                              Bold : If we want to change our text into Bold format, then we can use this command. Keyboard shortcut to use this command is Ctrl+B. In below image we have inserted a sample text in cell A1. If we click on the Bold icon from font group or use keyboard shortcut Ctrl+B, then the text from cell A1 will convert into Bold as shown in below image. Italic : If we want to convert our text into Italic format, then we can use this command. Keyboard shortcut to use this command is Ctrl+I. In below image we have inserted a sample text in cell A1. If we click on the Italic icon...
Read more

Insert WordArt in Excel

By
Image
In this blog post we will learn to insert WordArt in excel. WordArt can be used to provide attractive look while creating templates or dashboards. The WordArt command can be found in “Insert” tab and under “Text” group as shown in below image. Once we click on this WordArt command, we can find around 20 different WordArt options which we can use in our excel file. Out of these 20 different WordArt options, we can select any one of our choice. In this case we have selected the WordArt which is highlighted with red in below image. Once we click this red highlighted WordArt option, we can see the this WordArt is now appeared on our excel screen with message in textbox “Your text here”. We can edit the text in this WordArt just by selecting it and typing the letters which we want to enter. In this case we have inserted the name of our blog “ Excel Tricks with Tejraj ”. Providing Text Effects to WordArt: We can also provide special effects to the text in WordArt. When we click on the insert...
Read more