copy drag financial years
I would do it with a formula. Enter your starting fiscal year in, say, A1,
then use:
=left(a1,4)+1&"/"&text(right(a1,2)+1,"00")
and drag down.
Regards,
Fred
"Ben" wrote in message
...
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
|