Results 1 to 2 of 2

Thread: Formula to pull year from a date code and add to a string
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular mikecox39's Avatar
    Join Date
    Mar 2014
    Location
    San Diego
    Posts
    237
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula to pull year from a date code and add to a string

    I have a budget sheet that I am trying to automate. I want to create a new sheet at the end of each fiscal year.

    I want the current year for each charter to be picked up from the date I enter.

    https://app.box.com/s/ztj13byev9850nbn98fntrn6u90p1ydf

  2. #2
    Board Regular mikecox39's Avatar
    Join Date
    Mar 2014
    Location
    San Diego
    Posts
    237
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to pull year from a date code and add to a string

    My plan is to create a macro that would clear the previous fiscal year dates and replace them with the next fiscal year dates, starting with July of the current year and ending with June the following year and maybe using the result to get the year date added the the Quarterly strings on the right.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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