+ Reply to Thread
Results 1 to 2 of 2

Countifs for due and overdue dates and times

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    17

    Countifs for due and overdue dates and times

    Hi,

    I want to create a formulae to see how many things are due and overdue by 24h/48h/72h/5d/10d/>10days.
    All things due or overdue will say "In Progress" in column AD and the Completion Due Date and Time is in column U.
    My formulae for Due in 24h is: =COUNTIFS(Data!$AD:$AD,"In Progress",Data!$U:$U,">="&NOW()+1)
    My formulae for Overdue in 24h is: =COUNTIFS(Data!$AD:$AD,"In Progress",Data!$U:$U,">="&NOW()-1)
    To change to 24/48/72/5/10/>10 I change the end number to +1/+2/+3 etc and for overdue -1/-2/-3 etc.
    I want to know what is due/overdue in 24h, 48h, 72h in those times but my formulae is giving me the total that say "In Progress" without taking the date and time into account.

    Any ideas what im doing wrong?

    TIA

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Countifs for due and overdue dates and times

    Please include a sample worksheet. It will be easier to visualize the requirement. Substitute dummy data for any sensitive information.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Logical Dates - OVERDUE
    By kjmosp in forum Excel General
    Replies: 1
    Last Post: 06-20-2015, 06:43 AM
  2. [SOLVED] Help with displaying if dates are overdue
    By rhysp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2013, 04:53 AM
  3. Replies: 3
    Last Post: 02-09-2012, 06:57 PM
  4. Flagging overdue dates
    By weeksy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-06-2011, 05:51 AM
  5. Overdue dates with Criteria
    By rickyilas in forum Excel General
    Replies: 2
    Last Post: 09-14-2010, 12:25 PM
  6. [SOLVED] Due Dates / Overdue items
    By Nic in forum Excel General
    Replies: 5
    Last Post: 06-28-2006, 02:20 AM
  7. Problem overdue dates
    By crombes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2005, 03:44 AM

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