Please help more!

[shital]

Thanks Jason I recv. the ans. but when i change mode from
yly to hly or qty or monthly it's not working.

Put this in A5 and copy down as far you think you'll need
(meaning if A2 will never be more than 50, drag down to
A55:

=IF(ROW()-4>$A$2,"",DATE(YEAR($A$1)+ROW()-4,MONTH($A$1),DAY
($A$1)))

HTH
Jason
Atlanta, GA

I have field like
A1-Date of issue
A2-No. of Year
A3-Mode of Payment.

What i want to do is When i type no. of year and mode
(yly,Hly,Qty or month)if i type yly mode i should give
every yearly date from date of issue up to no. of year
enter in no. of year field.

it should like in
A5 1-11-03
A6 1-11-04
A7 1-11-05
A8 1-11-06
upto no.of year.

Please help me.

Shital
....

 

[Debra Dalgleish]

There were a couple of other replies to your original posting. You can
see them in the Google archive:


http://groups.google.com/groups?&[email protected]