Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The answer depends on how fussy you need / want to be about fractional
months. A person's exact age in terms of years is easy enough; months are trickier because they are not the same number of days. Here is a simplified way to do it, with the birthdate in A1 and the given date in B1. Assume a month is 365 / 12 days. The Years calculation is =INT((B1-A1)/(365/12)/12) The months calculation is =MOD((B1-A1)/(365/12),12) If you try this you'll likely get a result with decimal places in the months response, so you may want to apply a rounding protocol or at least be prepared to explain what the fractions truly mean. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IRR Calculations | Excel Discussion (Misc queries) | |||
Calculations seem to be off... | Excel Discussion (Misc queries) | |||
Calculations | Excel Worksheet Functions | |||
how many calculations? | Excel Worksheet Functions | |||
% calculations | Excel Worksheet Functions |