+ Reply to Thread
Results 1 to 3 of 3

Increase financial year by 1

  1. 05-08-2013, 11:32 PM #1
    BennyH
    BennyH is offline
    Registered User
    Join Date
    03-19-2013
    Location
    Rockhampton, Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Arrow Increase financial year by 1

    Hi,

    this should be simple but can't get it. I have 2012-13 in cell A1, how do i copy/paste(or use formula) to copy across 2013-14 in A2, 2014-15 in A3.

    Thanks
    Reply With QuoteRegister To Reply
  2. 05-08-2013, 11:50 PM #2
    mc84excel
    mc84excel is offline
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Increase financial year by 1

    In cell A2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    then just copy down
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************
    Reply With QuoteRegister To Reply
  3. 05-09-2013, 12:24 AM #3
    BennyH
    BennyH is offline
    Registered User
    Join Date
    03-19-2013
    Location
    Rockhampton, Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Increase financial year by 1

    Cool,

    got it thanks.Formula that i wanted is
    =LEFT(A1,4)+1&"-"&RIGHT(A1,2)+1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1