View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Ben is offline
external usenet poster
 
Posts: 509
Default copy drag financial years

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

Does anyone know how to get 2006/07, 2007/08 etc?

Thanks