Hi Robert ---

Check this out:

http://support.microsoft.com/support/kb/articles/q185/4/80.asp



>I have to calculate the age of a person in years and days. This has to be exact including a means of determining leap years.
>
>Example:
>If I have a person who joined our organization in 1943, paid his dues through 1965 and from Jan 10, 1966 through Mar 2, 1966 he failed to pay his dues, then from Mar 2 through today he is paid up.
>
>I know leap years are every four years, but there are exceptions. Year 2000 is one of them. Are there others? I have records going back to the early 1800's that need to be calculated.
>
>Ideas? I've already got a function but it doesn't take into account year 2000 or any other exceptions.
>
>Thanks
>Robert