Hi Ben,

Hi i use financial years a lot and was wondering if there was a simple way
to
copy, paste/drag the years down a column so they expand? For example when
i
drag the years down i get:
2006/07
2006/08
2006/09

You have received a few formula based approaches, another way of doing this
is by using custom lists.

Set up a custom list in Excel Options with the financial years.

Now enter a financial year in a cell. Click on the little dot at the corner
of the cell selector and drag. Financial years fill as expected.

Ed Ferrero
www.edferrero.com