+ Reply to Thread
Results 1 to 2 of 2

amount of days between a start date and end date within a particular quarter

  1. #1
    Registered User
    Join Date
    09-07-2023
    Location
    Denmark
    MS-Off Ver
    365 E3
    Posts
    1

    Unhappy amount of days between a start date and end date within a particular quarter

    A few quick admissions... I'm not an expert in Excel but I use it daily. I've tried with multiple AIs but either they don't get it or I'm not explaining it very well :-(

    The issue..

    I have a start date in K1 and an end date in L1.
    Please reference the quarters (column A) and their years (Column B) as follows:
    A6 = 1, B6 = current year,
    A7 = 2, B7 = current year,
    A8 = 3, B8 = current year,
    A9 = 4, B9 = current year,
    A10 = 1, B10 = current year +1,
    A11 = 2, B11 = current year +1,
    A12 = 3, B12 = current year +1,
    A13 = 4, B13 = current year +1.

    I want to be able to see the amount of days from the start date(K1) and end date(L1) that fall within a particular quarter.

    In Excel, how to work out how many days a specific date range has in each quarter. The date range might span from one year to the next i.e. 1 Sept 2023 > 1 Feb 2024.

    Any help and/or guidance would be SO appreciated!

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,628

    Re: amount of days between a start date and end date within a particular quarter

    Please read yellow banner on top.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Replies: 3
    Last Post: 01-15-2016, 10:12 AM
  2. Replies: 1
    Last Post: 05-26-2014, 03:46 AM
  3. Calculate End Date Using Start Date and No. of Days excluding specific days.
    By SinusxCosinusx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2013, 05:48 AM
  4. Replies: 1
    Last Post: 08-21-2013, 02:14 PM
  5. Replies: 2
    Last Post: 03-22-2013, 02:20 PM
  6. Date Range - Start and End Date - Identify dates in a quarter
    By Nikki Fox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2012, 06:05 AM
  7. Replies: 2
    Last Post: 01-04-2012, 09:15 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