+ Reply to Thread
Results 1 to 2 of 2

Formula to count days overdue 5, 10, 15, 20, 25, 30, 60, 90+

  1. #1
    Registered User
    Join Date
    08-29-2010
    Location
    Cape Town
    MS-Off Ver
    Excel 2003
    Posts
    9

    Formula to count days overdue 5, 10, 15, 20, 25, 30, 60, 90+

    HI all,

    I have a spreadsheet that I extract from Our Asset system, I use this to measure the performance of the procurement team, and its time consuming adding the things up manually. I use a lookup list to find the information in the worksheet, but i would like to calculate automatically the total count of items that fall into the 5 days overdue, 10 days overdue, 15 days overdue, 20 days overdue, 25 days overdue, 30 days overdue, 60 days overdue and 90+ days overdue, all measurred from the last weekending date as shown in the sheet. I just cannot get my head around this formula. Please can someone help me. See the attachment

    EAM Procrement MRO Status.xlsx

  2. #2
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Formula to count days overdue 5, 10, 15, 20, 25, 30, 60, 90+

    I know a little off topic, but I couldn't resist stating.... When I first openned the workbook up I had a sudden urge to play Uno or Simon Says... That is one of the most colorful pie charts I've seen... I like it.


    My brain just can't function today for some reason and I just can't finger things out... If no one has gotten back to you on this, I'll try and work on it after my coffee has kicked in.
    Last edited by vamosj; 10-30-2013 at 11:31 AM.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

+ 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. [SOLVED] Average number of days overdue, between date ranges
    By PJC2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2013, 03:01 PM
  2. Formula to determine total overdue values by length of overdue
    By Midnight_Dragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 02:03 AM
  3. Producing a flag or highlight when an item is 14 days overdue
    By danny06m in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 04:30 AM
  4. [SOLVED] Formula for Days Overdue if not Completed
    By excelnewb02 in forum Excel General
    Replies: 5
    Last Post: 09-11-2012, 04:51 AM
  5. Days Overdue Column
    By Frank Sellin in forum Excel General
    Replies: 3
    Last Post: 09-13-2010, 11:32 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1