+ Reply to Thread
Results 1 to 4 of 4

COUNTIF formula if date is within certain month

Hybrid View

  1. #1
    Registered User
    Join Date
    10-25-2016
    Location
    Birmingham
    MS-Off Ver
    2010
    Posts
    12

    COUNTIF formula if date is within certain month

    Hi all, I am currently using this formula below to tell me the amount of cases in the current month

    =COUNTIFS(Casework!$B:$B,"Disciplinary",Casework!$AB:$AB,">"&EOMONTH(TODAY(),-1))

    Can you tell me how to change it to a specific month. E.g how many cases in October


    Thanks

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,998

    Re: COUNTIF formula if date is within certain month

    =COUNTIFS(Casework!$B:$B,"Disciplinary",Casework!$AB:$AB,">"&EOMONTH(TODAY(),-1))

    In implement in Red part of above formula you can change into current month as right now it is -1 in EOMONTH function with today function. Today function will give you current date and EOMONTH function can provide you whatever date you have it will give you that particular month's end date.

    EOMONTH(start_date, months)

    Start_date Required- A date that represents the starting date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

    Months Required. The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.

    Note- (-1) means before month last date, (+1) next upcoming month last date and 0 means current month last date.

    Hope it will help you. If you wish current month then just put 0 instead on (-1)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,177

    Re: COUNTIF formula if date is within certain month

    Try this ...

    =COUNTIFS(Casework!$B:$B,"Disciplinary",Casework!$AB:$AB,">="&DATE(2016,10,1),Casework!$AB:$AB,"<"&DATE(2016,11,1))

  4. #4
    Registered User
    Join Date
    10-25-2016
    Location
    Birmingham
    MS-Off Ver
    2010
    Posts
    12

    Re: COUNTIF formula if date is within certain month

    That's great thanks

+ 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: 09-13-2016, 10:14 AM
  2. [SOLVED] Need Formula that will show 'Month" for date that fall in the particular month
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2014, 01:47 PM
  3. Replies: 6
    Last Post: 05-21-2014, 02:21 PM
  4. COUNTIF the date falls within a month
    By Patty McJorst in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2013, 10:43 AM
  5. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  6. Replies: 3
    Last Post: 09-25-2007, 10:26 AM
  7. CountIf by Month-to-date
    By ashley0578 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2006, 11:30 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