+ Reply to Thread
Results 1 to 4 of 4

Combining the IF Function with a countdown to show a project "Completed"

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Combining the IF Function with a countdown to show a project "Completed"

    Hello all, thanks in advance for responding to my first post.

    I'm designing a spreadsheet for use by my law firm, and the idea is to track due dates and show when things are filed or completed.

    We have three cells being used in this case - a "due date" cell, a "filed date" cell and a "days until due" cell. I have a countdown setup so that the days until due cell currently shows how many days are left until the item is due - which is simply:

    =U5-$A$1

    Where U is the "due date" column, and A1 is today's date.

    What I can't figure out how to do is make the "days until due" cell show up as filed when a date is inputted into the "filed date" cell.

    So for example, let's say the due date is September 15, 2013 and the days until due counter is showing that we have six days until it's due. I would like that same cell to say "FILED" as soon as someone inputs the date it was filed into a separate cell.

    Thanks again...

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Combining the IF Function with a countdown to show a project "Completed"

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    09-09-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Combining the IF Function with a countdown to show a project "Completed"

    My faith in humanity has been restored! Thank you TMS.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Combining the IF Function with a countdown to show a project "Completed"

    You're welcome.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. VBA - Only show datepicker if ComboBox value = "Completed"
    By matrix_fan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2013, 06:12 AM
  2. Trying to figure out how to add ,"" to already completed If(and) Function
    By Tailoredcs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2013, 06:02 PM
  3. If "Completed" then move entire row to "Completed" worksheet
    By Reed1620 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2013, 01:59 PM
  4. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  5. Problem Combining "Paste Link" & "Insert Rows"
    By o'h3nry in forum Excel General
    Replies: 1
    Last Post: 05-14-2010, 03:15 PM

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