Posted to microsoft.public.excel.worksheet.functions

Ben

external usenet poster

Posts: 509

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Paste Financial Years	Ben	Excel Worksheet Functions	3	January 22nd 10 06:48 AM
Financial Years	James B	Excel Discussion (Misc queries)	3	February 20th 07 09:42 PM
Copy and paste financial formulas	Cliff	Excel Worksheet Functions	1	January 30th 07 04:49 PM
URGENT IF STATEMENT REQUIRED:True if moving between financial years?	Ray Everingham	Excel Worksheet Functions	3	May 26th 06 09:30 PM
year function and financial years	Martin_London	Excel Worksheet Functions	5	December 5th 05 11:20 PM

All times are GMT +1. The time now is 10:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us