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!

1 comment:

  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