+ Reply to Thread
Results 1 to 11 of 11

How can i Count Status between two dates

  1. 04-05-2014, 02:26 AM #1
    mahender5
    mahender5 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    How can i Count Status between two dates

    Dear Friends,

    I am Mahender i would like to know little thread which could i got troble.

    I have an excel contains Works i have recieved like

    i received a work on 01.Apr.2014 i have commited to completed the same on 04.Apr.2014 and completed on 05.Apr.2014 or some one are completed before cpmmited date abd before commited date.

    Hence i would like to track the work complition within commited date,
    and the work complition within not commited date and work still not completed.

    enclosed sample excel


    I request you to plz help me on this...

    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-05-2014, 02:37 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How can i Count Status between two dates

    Have a look at the attached for one way of doing this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 04-05-2014, 06:19 AM #3
    mahender5
    mahender5 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How can i Count Status between two dates

    Thanq Mr BadlySpelledBuoy for your favourble responce,
    Even i have query on this plz find the same.



    I am Mahender i would like to know little thread which could i got troble.

    I have an excel contains Works i have recieved like

    i received a work on 01.Apr.2014 i have commited to completed the same on 04.Apr.2014 and completed on 05.Apr.2014 or some one are completed before cpmmited date abd before commited date.

    Hence i would like to track the work complition within commited date,
    and the work complition within not commited date and work still not completed.

    enclosed sample excel


    I request you to plz help me on this...

    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-05-2014, 11:44 AM #4
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How can i Count Status between two dates

    I'm not sure if the latest reply means I helped or not...
    Reply With QuoteRegister To Reply
  5. 04-05-2014, 12:50 PM #5
    mahender5
    mahender5 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How can i Count Status between two dates

    Quote Originally Posted by BadlySpelledBuoy View Post
    I'm not sure if the latest reply means I helped or not...
    No doubt u r post was 100% useful to me my dear friend.
    I request u too plz help me on my 2 query which I posted
    Reply With QuoteRegister To Reply
  6. 04-05-2014, 01:07 PM #6
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How can i Count Status between two dates

    I think this is what you mean.

    You've already created a "helper column" of sorts in column G, so I've amended the formula in there slightly.
    You can then populate cells K10:K13 with COUNTIF based on that helper column (as I have done).
    Last edited by BadlySpelledBuoy; 04-05-2014 at 01:11 PM. Reason: Deleted attachment as it was incorrect.
    Reply With QuoteRegister To Reply
  7. 04-05-2014, 01:10 PM #7
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How can i Count Status between two dates

    Apologies, I forgot to lock the cell references in K10:K13 on that version.
    Try this one.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-05-2014, 01:41 PM #8
    mahender5
    mahender5 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How can i Count Status between two dates

    Quote Originally Posted by BadlySpelledBuoy View Post
    Apologies, I forgot to lock the cell references in K10:K13 on that version.
    Try this one.
    Dear Friend,

    I feel very happy about u r responce..
    Its very nice loop. Thanks a million.

    My special cordial greetings.

    Regards,
    Mahender
    Reply With QuoteRegister To Reply
  9. 04-05-2014, 01:43 PM #9
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How can i Count Status between two dates

    No problem Mahender. Happy I could help.

    Please ensure you mark the thread as SOLVED.

    BSB.
    Reply With QuoteRegister To Reply
  10. 04-07-2014, 12:41 AM #10
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: How can i Count Status between two dates

    Mahender I am happy that you got the answer you wanted

    To mark a thread solved, use the Thread Tools towards the top of the page. There is no need to "report" the thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  11. 04-07-2014, 02:04 AM #11
    mahender5
    mahender5 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How can i Count Status between two dates

    Dear Badly,

    Your Loop was very cute to count the status but i would like to count the same between two dates as attached.
    plz have look.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF formula with different status dates
    By mbay in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-27-2013, 10:26 AM
  2. [SOLVED] Display latest status in Final Status column after comparing the status on three dates
    By shekharnyk in forum Excel General
    Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  3. IF Function- Deadline dates and Status
    By zeppelinmike in forum Excel General
    Replies: 11
    Last Post: 11-13-2011, 07:46 AM
  4. Dates and status
    By shajms75 in forum Excel General
    Replies: 0
    Last Post: 03-31-2011, 07:26 AM
  5. Dates- Updating to show the status
    By WTB in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-30-2010, 09:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1