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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05