+ Reply to Thread
Results 1 to 4 of 4

Assistance Needed: Unable to count status value for given month (between 2 dates)

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    NY, New York
    MS-Off Ver
    MS Office Pro Plus 2010
    Posts
    2

    Post Assistance Needed: Unable to count status value for given month (between 2 dates)

    Column-A----------Column-B----------Column-C
    STATUS----------Date----------Work Type

    Submitted----------9/29/2015----------Installation
    Assigned----------9/29/2015----------Installation
    Assigned----------9/30/2015----------Installation
    Assigned----------10/1/2015----------Installation
    Submitted----------10/1/2015----------Device Installation
    No BID----------10/1/2015----------Installation
    Submitted----------10/2/2015----------Installation
    Submitted----------10/2/2015----------Device Installation
    No BID----------10/21/2015----------Device Installation
    Submitted----------10/21/2015----------Device Installation
    Submitted----------10/29/2015----------Installation
    No BID----------10/29/2015----------Installation
    No BID----------11/2/2015----------Installation
    Pending----------11/2/2015----------Installation
    Assigned ----------11/2/2015----------Installation

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Assistance Needed: Unable to count status value for given month (between 2 dates)

    Hi TCG and welcome to the Forum. Without more particulars I just made up a date range using the DATE function. In your live data you could probably refer to a helper cell. For Status you could also refer to a helper cell or better yet a drop-down cell. In the meantime perhaps something like this will get you started in the right direction.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 11-13-2015 at 03:27 AM. Reason: added comments
    Dave

  3. #3
    Registered User
    Join Date
    09-22-2015
    Location
    NY, New York
    MS-Off Ver
    MS Office Pro Plus 2010
    Posts
    2

    Re: Assistance Needed: Unable to count status value for given month (between 2 dates)

    Thank you so much!!!!
    I have been trying to figure this out for a week, and the formula works exactly the way I needed it!!

    Have a wonderful start to your weekend!!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Assistance Needed: Unable to count status value for given month (between 2 dates)

    You're welcome. Glad it does the job, and 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. Replies: 5
    Last Post: 06-28-2015, 08:28 PM
  2. [SOLVED] Countifs Formula needed to count # of dates in same month that also is in same state.
    By Stanimal in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-12-2014, 02:43 PM
  3. How can i Count Status between two dates
    By mahender5 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2014, 02:04 AM
  4. Assistance needed (Have to convert string of numbers into dates)
    By connmtc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 08:23 PM
  5. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 PM
  6. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  7. Replies: 4
    Last Post: 03-29-2012, 09:01 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