+ Reply to Thread
Results 1 to 2 of 2

Analyzing whether a project was on time or late

  1. #1
    Registered User
    Join Date
    05-18-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2003
    Posts
    29

    Analyzing whether a project was on time or late

    I need a spreadsheet that will look at specific columns and determine based on the calendar dates entered in those columns whether a project was a) submitted On Time or Late, and b) the # of Days Early/Late it was submitted. Please see the attached spreadsheet as an example. I have highlighted in green what I'd like the spreadsheet to automatically populate.

    Thanks!! I really love this forum.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-18-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Analyzing whether a project was on time or late

    I believe I answered my own question. Here is the formula I used to populate whether a task was On Time or Late with L4 being the column showing the Due Date and M4 being the Submitted Date.
    =IF(L4>=M4,"On Time","Late")

    Here is the column for the # of days Early and Late.
    =IF(COUNT(L4,M4)=2,TEXT(M4-L4,"0 ""Day(s) Late"";0 "" Day(s) Early"";""0 Day(s) Early"""),"")

    Hope this info helps someone else out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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