+ Reply to Thread
Results 1 to 9 of 9

Formula to count days and reset count

  1. 05-25-2015, 09:47 PM #1
    daviddelatorre
    daviddelatorre is offline
    Registered User
    Join Date
    05-07-2015
    Location
    usa
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Formula to count days and reset count

    Hi! I need some help with formula to count days of different Users ID like the example I have on column D and then reset the count if I have a value grater than zero on column C
    Day count.xlsx
    Thanks.
    Reply With QuoteRegister To Reply
  2. 05-26-2015, 08:56 AM #2
    VictorHPA
    VictorHPA is offline
    Registered User
    Join Date
    05-21-2015
    Location
    Brazil
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Formula to count days and reset count

    What is the criteria to add days to the count?
    Reply With QuoteRegister To Reply
  3. 05-26-2015, 09:23 AM #3
    daviddelatorre
    daviddelatorre is offline
    Registered User
    Join Date
    05-07-2015
    Location
    usa
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Re: Formula to count days and reset count

    Hi! this is what I have so far, I have this formula =IF(B2=$B1:B$2,DATEDIF($A$2,A2,"D"),0) on column E but is only counting on the first User ID 114662 but not for 111111, but is still I don't know how to reset the count if I have a value grater than zero on column C and start the count from where the reset count is.

    Thanks.
    Last edited by daviddelatorre; 05-26-2015 at 09:35 AM.
    Reply With QuoteRegister To Reply
  4. 05-26-2015, 11:02 AM #4
    daviddelatorre
    daviddelatorre is offline
    Registered User
    Join Date
    05-07-2015
    Location
    usa
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Re: Formula to count days and reset count

    Bump

    Thanks.
    Reply With QuoteRegister To Reply
  5. 05-26-2015, 11:06 AM #5
    VictorHPA
    VictorHPA is offline
    Registered User
    Join Date
    05-21-2015
    Location
    Brazil
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Formula to count days and reset count

    The function above has tree arguments: the date range, User ID range and reset count range (in the specific row that you start the count). So paste the code into one module and the formula "=SpecialCount(A3,B3,C3)" in cell "E3".

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-26-2015, 11:30 AM #6
    daviddelatorre
    daviddelatorre is offline
    Registered User
    Join Date
    05-07-2015
    Location
    usa
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Re: Formula to count days and reset count

    Hi! I pasted the code to a module and pasted the formula on E3 an E3 is showing #NAME?. I am doing something wrong.

    2015-05-26 10-27-32_Day count (1).png
    Reply With QuoteRegister To Reply
  7. 05-26-2015, 12:07 PM #7
    VictorHPA
    VictorHPA is offline
    Registered User
    Join Date
    05-21-2015
    Location
    Brazil
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Formula to count days and reset count

    Lets try the attached file.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 05-26-2015, 06:38 PM #8
    daviddelatorre
    daviddelatorre is offline
    Registered User
    Join Date
    05-07-2015
    Location
    usa
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Re: Formula to count days and reset count

    Hi! Victor this is almost what i need but column E is not working right on some rows does not count the days or when there a one does not reset. Can you help me out with this?

    Thanks!


    Day count.xlsm
    Reply With QuoteRegister To Reply
  9. 05-27-2015, 09:25 AM #9
    VictorHPA
    VictorHPA is offline
    Registered User
    Join Date
    05-21-2015
    Location
    Brazil
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Formula to count days and reset count

    Hello,

    Ok, Error will occur when value should be "0". That is why i put one "IFERROR" formula.
    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. Rolling Count Formula with Reset
    By ctrapper in forum Excel General
    Replies: 7
    Last Post: 10-23-2014, 03:33 AM
  2. Help me! I want to count the working days of worker with count and if array.
    By tuyetngapt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2013, 12:52 AM
  3. Count formula for dates greater than 30 days old with exclusions and not count blanks
    By mmennealy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2012, 05:25 PM
  4. Count till met criteria, reset counter and count further
    By Romas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2011, 01:42 PM
  5. Formula To Reset a Count Based On Cell Value
    By TheLostBoy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-04-2009, 11:38 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