+ Reply to Thread
Results 1 to 3 of 3

How to count number of months between two dates that fall within a quarter in excel?

  1. #1
    Registered User
    Join Date
    05-26-2022
    Location
    Uk
    MS-Off Ver
    Excel
    Posts
    1

    How to count number of months between two dates that fall within a quarter in excel?

    I have a table with start date and end date. I need to count how many months fall within Quarter4 2021 and Quarter1 2022, so I can count profit per quartal. Revenue recognition is based on a month service.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: How to count number of months between two dates that fall within a quarter in excel?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: How to count number of months between two dates that fall within a quarter in excel?

    Removed due to prior post
    -If you think you are done, Start over - ELeGault

+ 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. [SOLVED] Check if dates fall on a given quarter
    By chaliseyp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2021, 02:20 AM
  2. Replies: 3
    Last Post: 12-21-2020, 05:42 AM
  3. [SOLVED] Count number of dates in a list that fall within a given month.
    By Gooford in forum Excel General
    Replies: 3
    Last Post: 04-25-2018, 10:24 AM
  4. count days that fall within specified quarter from large range
    By amajor99 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-15-2017, 03:39 PM
  5. [SOLVED] Count number of months between two dates
    By nadeem.ansari1980 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-21-2014, 02:36 PM
  6. [SOLVED] Counting Dates that Fall in Specific Quarter
    By tylerf in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-19-2013, 03:30 PM
  7. Replies: 3
    Last Post: 08-08-2005, 06:05 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