Presumably there is some relationship between the input years and the dates from 4 years earlier. I doubt, though, that you'd want to be hard-coding the dates for every few years. If you can say what that relationship is, it should be possible to code the form to output the dates regardless of what the input year is. As for the input year, is it always a June date? If not, you need to provide the logic for how the months relate to C, D, E & F.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]