+ Reply to Thread
Results 1 to 7 of 7

Countif Date less than 3 months from another Date AND another column=certain month

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Countif Date less than 3 months from another Date AND another column=certain month

    Hi Everyone,

    First post here. Bare with me.. I'm extremely new to this. I'm trying to do something difficult on a spreadsheet and need some assistance. I've attached it below.

    So I am trying to count (in row 58) people that are enrolled in certain month(column D) AND Column AL <= 3

    I will be doing the same in Row 59, but for folks where column AL = between 3 and 6 months.

    Obviously if I can do this with removing column AL altogether, that would be preferable.

    Thank you!!



    upload.xlsx

  2. #2
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    I also need to note that clearly some of my formulas are going to run into issues when next year rolls around and I have multiple months, but different years. I need a way to change the formulas at the bottom to only include 2014... And I will make another large section for 2015.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,775

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    Have a look at the attached for one way of doing this. Any good to you?

    It's based on 30 day months so within three months would be 90 days or less and 3-6 months would be greater than 90 and less than or equal to 180 days etc.

    I've changed the date format in row 51 to help out with replicating the table for other years.

    No need for column AL.

    BSB
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    You are absolutely phenomenal for that. Works like a charm.

    Could you possibly help me convert the other formulas to operate base on the month/year in row 51 as well? The formulas you have added are excellent, but are way over my head.

    Thank you!

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,775

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    Here you go. All done.

    These formulas you could use COUNTIFS for (it's a little more efficient than SUMPRODUCT), but I've used SUMPRODUCT for them as didn't want to confuse you with more formulas.

    BSB.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    Thank you SO much!

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,775

    Re: Countif Date less than 3 months from another Date AND another column=certain month

    No problem. Happy to help.

    BSB.

+ 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: 1
    Last Post: 12-22-2013, 08:04 AM
  2. VBA. If date = first day of the month then return months value (e.g. November)
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-06-2012, 09:04 AM
  3. Take user input start date and end date. Create a column for each month between these
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2010, 11:46 AM
  4. Replies: 7
    Last Post: 05-29-2009, 08:03 AM
  5. how to program the Exipred Date column to show the date 6 months
    By sgunn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2007, 04:14 PM

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