View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default age calculations

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.