Hi,

I'm creating a program used to calculate teacher’s pensions for when they retire. Part of this program requires the reckonable service to be calculated to whole days. The brief has specified that a year is 365 days and that leap-years are to be ignored, therefore the DateDiff function is out of the question.

I need to work out the number of years and days between two dates, and I can’t for the life of me think how to do this.

The test criterion is that 32 years 130 days = 32.356 years.

Can anyone help?

Cheers,
Adzi