Results 1 to 5 of 5

Completion dates that show past due and recognized if already completed and is late

Threaded View

Cgoyette Completion dates that show... 04-08-2014, 03:55 PM
alansidman Re: Completion dates that... 04-08-2014, 04:47 PM
Cgoyette Re: Completion dates that... 04-08-2014, 05:09 PM
easyexcelanswers Re: Completion dates that... 04-08-2014, 05:16 PM
Cgoyette Re: Completion dates that... 04-08-2014, 05:42 PM
  1. #5
    Registered User
    Join Date
    04-08-2014
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Completion dates that show past due and recognized if already completed and is late

    =IF(0<D2<=C2, "on time",IF(AND(B2>C2, D2=""), "past Due", IF(D2>C2, "late", "on time")))

    sorry doesn't work

    I get on time and late but it should have some PAST dues since the vehicle is not done yet.

    The vehicles that do not have a completed date should be shown as past due. No value is in that cell and that may be what the hang up is.

    This one is killing me.

    Curt
    Last edited by Cgoyette; 04-08-2014 at 05:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting with approaching due dates and completed dates
    By rogernation in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2013, 04:12 PM
  2. [SOLVED] Template for tracking project completion dates and simple metrics? % Completed on time
    By Shrad013 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 10:28 AM
  3. [SOLVED] Move Rows from one worksheet to another if 30 days past completion date
    By leerjeddar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 01:13 PM
  4. Replies: 4
    Last Post: 04-18-2012, 07:17 AM
  5. Overdue/late completion/completed tasks
    By BRISBANEBOB in forum Excel General
    Replies: 6
    Last Post: 01-14-2009, 04:04 PM

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