+ Reply to Thread
Results 1 to 2 of 2

Need Quarter wise name from Date

  1. 04-20-2021, 05:55 AM #1
    ulya1986
    ulya1986 is offline
    Registered User
    Join Date
    10-30-2018
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    1

    Need Quarter wise name from Date

    Hi,

    I have different dates and need the quarter wise details

    Below the option require against each date

    Jan-Mar
    Apr-Jun
    Jul-Sep
    Oct-Dec

    Can I get this from formula or any function against the date
    Reply With QuoteRegister To Reply
  2. 04-20-2021, 10:20 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,411

    Re: Need Quarter wise name from Date

    You could create a list repeating each quarter description three times and then use the month number to index that list.

    For example:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    where A1:A12 contain the list.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    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)

Similar Threads

  1. [SOLVED] Sorting Shares sale, script-wise and date-wise
    By bal1 in forum Excel General
    Replies: 13
    Last Post: 03-11-2021, 10:10 AM
  2. Return a quarter wise best,poor performed Vehicles name and Values
    By Mohammad Munawar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-14-2020, 06:47 AM
  3. [SOLVED] how to get week day wise, date wise value from raw data
    By emmr in forum Excel General
    Replies: 5
    Last Post: 09-04-2020, 07:21 AM
  4. [SOLVED] Calculate Quarter (date) and Calculate Average of Quarter and Sum of Quarter
    By Bobbbo in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-26-2020, 06:16 PM
  5. need formula to get same result from total as per Quarter wise
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-07-2016, 01:13 PM
  6. [SOLVED] date wise /name wise total with round function
    By hkbhansali in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2014, 11:37 AM
  7. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1