Thursday, January 15, 2015

MS Excel Formula for Calculate Age by Entering Date of Birth

Formula: =TRUNC((DAYS360(D1,today(), FALSE))/360, 0)

D1:  is your target cell for input date of birth
today(): is the formula to return the date of today




Then, the cell with this formula returns the age of input.



Easy!

2 comments:

  1. Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.

    ReplyDelete
  2. Hi,

    find Age Calculator then it is Overall looking for a Chronological age or anniversary calculator then this is your best option in age Calculator.

    Age Calculator By Date Of Birth (Days, Months)
    Calculation of age with interesting details!
    If you want to know the details of your age, then install the Age Calculator

    ReplyDelete