incrementing date

[ZOHAR]

Respected,
I have to calculate the age of a member of family relative to the reference date added at the top of the table
The reference date has to be added in MM-YYYY format in d1
for the first month the date is same as the reference month
but in second month of the quarter the date has to be incremented
and relative to that the age of the family member has also to be incremented.
-------
in d1 I inserted 01-2000 and the age of a family member at that time is 25.03
then at the place of first quarter should be
cell date age
b45 01-2000 25.03
b46 02-2000 25.04
b47 03-2000 25.05
first quarter ends
-------------
second quarter
b62 04-2000 25.06
b63 05-2000 25.07
b64 06-2000 25.08

This figures I am able to add manually but I want that as and when I add the starting date and age of a member(totally 8) the rest of data (40 years) should be generated automatically by formulae.

THANX IN ADVANCE

Zohar
please CC: [email protected]
as I posted this thread third time.

[starguy]

Respected,
I have to calculate the age of a member of family relative to the reference date added at the top of the table
The reference date has to be added in MM-YYYY format in d1
for the first month the date is same as the reference month
but in second month of the quarter the date has to be incremented
and relative to that the age of the family member has also to be incremented.
-------
in d1 I inserted 01-2000 and the age of a family member at that time is 25.03
then at the place of first quarter should be
cell date age
b45 01-2000 25.03
b46 02-2000 25.04
b47 03-2000 25.05
first quarter ends
-------------
second quarter
b62 04-2000 25.06
b63 05-2000 25.07
b64 06-2000 25.08

This figures I am able to add manually but I want that as and when I add the starting date and age of a member(totally 8) the rest of data (40 years) should be generated automatically by formulae.

THANX IN ADVANCE

Zohar
please CC: [email protected]
as I posted this thread third time.

please attach a sample file in zip format for better consideration.

[olasa]

I don't think this will solve your problem, but it might give some ideas.
//Ola

[Bryan Hessey]

I don't think this will solve your problem, but it might give some ideas.
//Ola

Hi,

Ola, it looks good except that you are countng months as 1 to 12, followed then by '1 yr 1 mth' etc, whereas if you omit your +1 then you will count as 0 to 11, ie, 11 months will be followed by 1 year 0 mths.

Further help could be obtained from http://www.cpearson.com/excel/datedif.htm#Age in the 'person's age' paragraph, use the A column date in place of the displayed Now()

hth
---