+ Reply to Thread
Results 1 to 2 of 2

Naming the Quarter between two dates

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    16

    Naming the Quarter between two dates

    Hi,,

    I'm not sure if this request should be here under the VB forum,,I'm not even sure if its possible to do,,

    What I want to be able to do is,,press the Q key and either Q1, Q2, Q3 or Q4 based on certain parameters appear in that cell,,

    Hopefully I can explain this clearer,,

    In column A of my spreadsheet heading 'Quarter', I want to be able to specify which quarter of the year a request was made,,so when I press Q

    > if the date is within 01/01/14 and 31/01/14 'Q1' will appear

    > if the date is within 01/04/14 and 30/06/14 'Q2' will appear etc,,I'm sure you can workout Q3 and Q4,,

    Ive named a cell A1 'TODAY' for reference it has the formula =TODAY() in it and shows whatever the date,,

    I have looked at the DATE commands available but I don't think any could do what I need, that's why I was thinking I needed a piece of VB code,,

    Any help would be much appreciated,,

    Regards,
    KJMOSP

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,942

    Re: Naming the Quarter between two dates

    Copy the code below, select the sheet, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Then save the file as a macro-enabled workbook.

    When you want to enter a Qx value, just select the blank cell in column A where you want the Qx value and it will appear. IF you need to change a value, you can just delete it and re-select that cell or just type over it. If you want to select a cell in column A without entering a Qx, select two cells instead of one.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Naming the Quarter between 2 dates
    By kjmosp in forum Excel General
    Replies: 2
    Last Post: 03-13-2014, 08:59 PM
  2. Calculating Fiscal Quarter End Dates
    By tgause in forum Excel General
    Replies: 4
    Last Post: 05-24-2010, 05:35 PM
  3. Calculating Fiscal Quarter End Dates
    By tgause in forum Excel General
    Replies: 6
    Last Post: 05-24-2010, 12:55 AM
  4. Excel 2007 : Calculating Quarter Start Dates
    By mlh4041 in forum Excel General
    Replies: 2
    Last Post: 10-19-2009, 10:26 AM
  5. Quarter between two dates ?
    By RAKESH230583 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2009, 06:11 AM

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