+ Reply to Thread
Results 1 to 7 of 7

countif based on certain month due date

  1. #1
    Registered User
    Join Date
    01-07-2024
    Location
    Indonesia
    MS-Off Ver
    2021
    Posts
    16

    countif based on certain month due date

    hello,

    i have a table contains customers that has 4 items. every items has its own due date.
    how to count how many items that has due date on march 2024?

    thanks before

    Simulation 4.xlsx

    simulation 4.PNG
    Last edited by johan58; 03-19-2024 at 10:03 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,229

    Re: countif based on certain month due date

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: countif based on certain month due date

    Try this in G2 and copy down.

    Please Login or Register  to view this content.
    PS. D3's date wrong, it should be 2024/3/30

  4. #4
    Registered User
    Join Date
    01-07-2024
    Location
    Indonesia
    MS-Off Ver
    2021
    Posts
    16

    Re: countif based on certain month due date

    Quote Originally Posted by Fluff13 View Post
    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    amazing thank you

  5. #5
    Registered User
    Join Date
    01-07-2024
    Location
    Indonesia
    MS-Off Ver
    2021
    Posts
    16

    Re: countif based on certain month due date

    Quote Originally Posted by windknife View Post
    Try this in G2 and copy down.

    Please Login or Register  to view this content.
    PS. D3's date wrong, it should be 2024/3/30
    yes im sorry, it should be in 2024.
    amazing function thank you very much

  6. #6
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: countif based on certain month due date

    You are welcome.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,229

    Re: countif based on certain month due date

    Glad to help & thanks for the feedback

+ 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] Countif Formula for Month and Date
    By cartica in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 11-10-2017, 10:02 AM
  2. COUNTIF formula if date is within certain month
    By DavyB9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2016, 07:20 AM
  3. Replies: 3
    Last Post: 09-13-2016, 10:14 AM
  4. [SOLVED] Countif based on month
    By bnwash in forum Excel General
    Replies: 6
    Last Post: 07-09-2014, 12:22 AM
  5. Replies: 6
    Last Post: 05-21-2014, 02:21 PM
  6. [SOLVED] countif based on month
    By superboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2013, 04:42 AM
  7. CountIf by Month-to-date
    By ashley0578 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2006, 11:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1