What is the Command for Calculating Age on MS EXCEL?

1.            Create a new excel file you excel software in your computer, tablet or online using outlook.com. Open the created excel file.

2.            Enter necessary data. Let’s consider you have entered data containing the following (or similar).Here;

              Cell-A1 is labeled as ‘Name’.

                Cell-B1 is labeled as ‘Date of Birth’.

                Cell-C1 is labeled as ‘Entry Date’.

3.            Now let’s select a column and name it ‘Age’. Which means in our excel sheet, the cell-D1 will be labeled as ‘Age’.

4. Select the first empty cell in the ‘Age’ (which will be cell-D2). Here in the D2 cell you have to type in a command by following instructions below;

                Type in =DATEDIF(.

                Then click on the cell-B2 or type it in.

                Press the comma key ( , ) to move to the next cell,

                Click on the cell-C2 or type it in.

                Again press the comma key ( , ),

                Now type "Y" (with quotation marks).

                type ) [close parenthesis]

The whole command will look like this; =DATEDIF(B2,C2,"Y"). Here in place of “Y” you can use; “M” for calculating age in months. “D” for calculating age in days.

5.  Copy the formula from the cell-D2 (original/first cell) and paste it to the cells below by keyboard shortcut CTRL + V, or you can simply take the mouse cursor to the right bottom corner until you see the pointer changes to crosshair (see the image below) . Left click + Hold + Drag the cursor by scrolling to the bottom of the column as bottom as your data goes.

                6.  Immediately the results are generated for each person’s age.

7.  Don’t forget to save the Excel sheet.