[Solved] Formulas: Dates

    I would like to create a formula to calculate the number of days between the current date and a specific date in excel.
    Is it possible to do this so that the current date automatically updates, so I see the new number of days when I open Excel?
    The goal is simple, I am tracking projects for work, and I need to know if any go past their target dates. I have attempted a formula in VBA to automatically update the current date, and turn any projects that are 14 days overdue red --and while it just looks lovely:biggrin:, it basically does nothing:(
    The spreadsheet I am using tracks many projects, it is done in Excel 2000 and I use WinXP & Win98 (two work stations)
    Thanks for any help you can give.
    :yes:

    You can tell the quality of a person by how they treat people they don't need

    Try this:
    Assumes due date is in col C2:C100
    and # of days in col D2:D100


    In a cell off to the side of your data; say H1, enter =TODAY()


    In D2 enter: C2-$H$1 and copy down; this returns the number of days between the current date and the date in col C


    Conditional format col D for >14 days


    2rrs

    Same sort of idea as the rr-meister but with a twist...


    Define a Name in your workbook (Insert|Names|Define)


    Call it Today


    In the Refers to box type
    =TODAY()


    Then you can use the following formula
    =A1-Today


    If A1 contained 30/11/2003, the result would be 30.


    Like I said, nothing clever, but using the "Name" avoids cluttering up your workbook with "static" values.... they can stay hidden.


    Will

    Thanks sooo much! You guys are the best!:spin::spin::spin:

    You can tell the quality of a person by how they treat people they don't need

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login