Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keith

"vezerid" wrote:

Keith,

there are several ways to tackle this. One way is to put the number
2002 in a cell, say K1. Then let us say you start with your fiscal
years in A3.

="FY "&$K$1+(ROW()-ROW($A$3))&" - "&$K$1+(ROW()-ROW($A$3))+1

Does this help?

Kostis Vezerides