+ Reply to Thread
Results 1 to 6 of 6

Subtracting quarters?

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    29

    Subtracting quarters?

    Hello! Thank you in advance for the help.

    I need to subtract quarters. For example, Q413-Q113=3. I cannot figure out how to do this.

    An alternate solution would be to convert the quarter to a date and subtract the dates, but I cannot figure out how to convert Q113 to 1/1/13, The dates go back too far to use nested if.

    I appreciate any help.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Subtracting quarters?

    What is your expected result? Are you trying to calculate the length in days of each quarter?

    Without knowing the values of Q413 or Q113 it's difficult to discern your intentions.

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Subtracting quarters?

    Hi,

    With the later and earlier in A1 and B1 respectively, perhaps:

    =4*(RIGHT(A1,2)-RIGHT(B1,2))+MID(A1,2,1)-MID(B1,2,1)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    07-12-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Subtracting quarters?

    I am trying to determine the number of quarters.

  5. #5
    Registered User
    Join Date
    07-12-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Subtracting quarters?

    XOR LX, That worked like a charm! Thank you so much!

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Subtracting quarters?

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Quarters and months
    By APPLEBEE in forum Excel General
    Replies: 6
    Last Post: 06-01-2011, 02:02 PM
  2. Excel 2007 : Sum Quarters
    By HangMan in forum Excel General
    Replies: 3
    Last Post: 06-25-2010, 06:13 AM
  3. 5 Rolling Quarters
    By ellis27 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-16-2009, 09:05 AM
  4. Working with Quarters
    By sabunabu in forum Excel General
    Replies: 3
    Last Post: 06-18-2008, 05:45 PM
  5. [SOLVED] End of the 4 quarters
    By ben simpson in forum Excel General
    Replies: 7
    Last Post: 03-12-2006, 01:30 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1