Results 1 to 8 of 8

Thread: Date Formula

  1. #1
    Join Date
    Aug 2006
    Posts
    5

    Question Unanswered: Date Formula

    Hello!!

    I'm working with a spreadsheet to manage the timely completion of work orders. I need a formula that results in Early, OK or Late depending on the Completion Date and refering to the completion period, for example:

    FROM TO COMPLETION DATE EARLY/LATE
    01/01/06 - 01/31/06 02/06/06 LATE

    I have tryed so many different ways but nothing

    Help me please!!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, and welcome to the board.

    Can you attach a sample file?

    Are the "From" and "Completion Date" in separate columns?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Aug 2006
    Posts
    5
    I'm trying to attach the excel spreadsheet but i get an error message.

    Yes they are to different columns


    thanks

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    If From Date is in B3, To Date is C3, and Competion Date is D3, then put this in cell E3

    =IF(D3>C3,"Late",IF(D3<C3,"Early","OK"))
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Aug 2006
    Posts
    5

    It didn't work

    it always returns late

    thanks

  6. #6
    Join Date
    Aug 2006
    Posts
    5

    Red face I'm Sorry!!

    Quote Originally Posted by leslieyosbe
    it always returns late

    thanks
    My mistake I was using 06 intead of 05
    that is why it was always late!!!

    Thansk for all your help, I really appreciate it!!

  7. #7
    Join Date
    Oct 2003
    Posts
    1,091
    Glad it worked. And thanks for coming back to verify that!

    Have an excel-lent day!
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  8. #8
    Join Date
    Aug 2006
    Posts
    5

    Wink Thanks

    Quote Originally Posted by shades
    Glad it worked. And thanks for coming back to verify that!

    Have an excel-lent day!
    You too!!

    Thank you very much for everything!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •