Results 1 to 5 of 5

Count Based on Join Date

Threaded View

journey0717 Count Based on Join Date 06-05-2020, 12:17 AM
BMV Re: Count Based on Join Date 06-05-2020, 01:34 AM
journey0717 Re: Count Based on Join Date 06-05-2020, 02:05 AM
BMV Re: Count Based on Join Date 06-05-2020, 03:15 AM
journey0717 Re: Count Based on Join Date 06-05-2020, 05:32 AM
  1. #1
    Registered User
    Join Date
    02-03-2020
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    28

    Count Based on Join Date

    Hi, I need help on analysis based on their join date.

    Example: Policy holder name (Chung Chee Ching), joined on 12/02/2020. Every policy holder have a fixed 84 days recruitment period to recruit new policy holders.

    Join date: 12/02/2020
    Due date: 6/5/2020

    If there is any recruitment for Chung Chee Ching, it will only count within the recruitment period.
    In this excel, there are total 3 appeared. However, the final result should be 2 based on the due date given for each policy holder who joined.
    Attached Files Attached Files

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: 02-28-2020, 04:15 AM
  2. Replies: 4
    Last Post: 07-06-2015, 08:39 AM
  3. Sorting and filtering data based on join date
    By ExcelHalp1 in forum Excel General
    Replies: 3
    Last Post: 12-18-2014, 10:47 PM
  4. [SOLVED] Count Unique Instances of Date while filtering based upon date and ID #
    By pmambrosetti in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2014, 02:22 PM
  5. Macro to join text inputs with slight variation provide a count of its repetition
    By eemrun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2014, 11:08 PM
  6. [SOLVED] To count the number of rows based on date and check how old the row is from current date.
    By raovv in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2013, 11:45 AM
  7. Replies: 2
    Last Post: 01-07-2011, 03:30 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