+ Reply to Thread
Results 1 to 4 of 4

Defining Quarterly dates..

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Defining Quarterly dates..

    Hi,

    I have a textbox and i just want to display on it the Current Quarter. So:

    Here's the breakdown:

    January-February-March = Q1
    April-May-June = Q2
    July-August-September = Q3
    October-November-December = Q4

    So if today is 'April' then textbox1 should be 'Q2' and so on and so forth.

    Thanks in advance!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Defining Quarterly dates..

    Hello siobeh,

    Here is one way...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Re: Defining Quarterly dates..

    Thanks Leith!

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Defining Quarterly dates..

    Hello siobeh,

    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. Quarterly dates problem
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 04:27 AM
  2. [SOLVED] Lookup quarterly periods against multiple dates
    By Xx7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2015, 04:13 AM
  3. [SOLVED] Splitting a Total Cost into Quarterly dates
    By paulhoskin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2013, 11:09 AM
  4. quarterly/weekly sales tracking with variable dates
    By blufyre in forum Excel General
    Replies: 1
    Last Post: 01-15-2012, 05:12 AM
  5. Dates to Quarterly formats HELP!
    By owenuk in forum Excel General
    Replies: 2
    Last Post: 11-29-2011, 02:23 PM

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