Calculate Age MSExcel

 Calculate Age with Excel

calculate age on MSExcel for a many applications by combining an undocumented function and the date format for cells. Microsoft Excel inside stores dates as serial numbers, which is the number of days a date is from Jan. 1, 1900. Please remember  as you set up your age calculation formula in MsExcel.

1-Open New Workbook Excel save with the name of calculate Age.

2- calculation by creating labels in the row of cells from A1 over to C1.

·                   

          Cell A1 should include a label pertaining to the opening date or start date. This may be the date an invoice was created or the birthday of a person.

     Cell B1 should include the label, "Today."

            Cell C1 should be labeled "Age."

3- Enter the variables for your age calculation in cells A2 and B2.

The invoice or birth date should be mention in cell A2.

          In cell B2, create the "Now" function by typing "=Now()" without the quotation marks. Press the "Enter" key to complete the entry.

·                                 If you like  more than one  person for which you want to know calculating age in days or years, you may b  mention  those variables in the rows down.

4-use the  "DATEDIF" function in cell .

Enter the Formula in the cell.

Type "=DATEDIF(" in the Formula Bar, without the quotation marks, and then click cell A2. =DATEDIF(birthday date cell,today date cell,"y")  example for year =DATEDIF(A2,B2,"y") and for month  =DATEDIF(A2,B2,"M") and for days =DATEDIF(A2,B2,"D")

      Click the cell B2 and press the comma key again.

          Enter the definition of your date interval, this time with quotation marks, and then press the "close parenthesis" key, ")".

5-Copy the formula in cell C2 and paste it into the cells in the C column for any other entries you have made.

         The formula will retain "relative references" to the cells in the A and B columns and will preserve the date interval definition from the original formula.