+ Reply to Thread
Results 1 to 10 of 10

Deadline Formulae

  1. #1
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Deadline Formulae

    Hi guys, need a bit of help here.

    I've got a formula that I'm working on for a spreadsheet.

    The sheet shows a list of dates etc.

    The formula I have set up currently is:

    =IF(TODAY()>=L2-3,"DUE","CURRENT")
    thats what i got so far, so basically, if the "deadline" is within 3 days the warning will change to "DUE"

    However, is it possible to have this "overidden" if the work has been completed, which would be populated in column O by a date.
    i.e. Completion Date (Column O) = 01/06/11. This would need to be applied to several hundred rows.
    So is there a way to do that, like IF column O has a date then "COMPLETE" not "DUE"?

    Thanks guys.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,548

    Re: Deadline Formulae

    Hi,

    Perhaps
    Please Login or Register  to view this content.
    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Deadline Formulae

    Perhaps
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Deadline Formulae

    Wow, thanks for the quick help guys, that was great!!

    Just going to make this a bit more complicated (for me at least)...

    Please Login or Register  to view this content.
    is the forumla you've given me.

    However,

    1) if the date in the L column is not entered (due to info not being supplied), can this say "current" rather than "due" ??

    2) if the date in the M column (amended due date) is active, it takes presidence over the L column?

    Thanks again guys, leaving rep for ya. =)

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,548

    Re: Deadline Formulae

    Hi,

    What, with respect to column M, does 'active' mean?
    If the M date is active what should appear?

    Regards

  6. #6
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Deadline Formulae

    Hi,

    The M column would have a date.

    L = due date
    M = amended due date

    so M will not always be filled out unless there are delays etc. to a project

  7. #7
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Deadline Formulae

    Perhaps
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Deadline Formulae

    Sorry for the late reply, been away.

    Wow, that's brilliant. Thanks a lot for all your help!! =D

  9. #9
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Deadline Formulae

    Sorry to bump and double post, is it possible to display if the completion date is after the due date it displays "FAILED" ?

  10. #10
    Registered User
    Join Date
    06-06-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Deadline Formulae

    Just giving this topic a lil bump. =)

+ 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