formula to figure out if 90 days past due

  • What would be the formula I could use to see if something was 90 days past due? I've entered the date of 4/30/05 in column A1 on the spreadsheet and 90 or more in column B1. I'd like the formula to calculate if something was 90 days or greater past due.


    Thank you

  • Re: formula to figure out if 90 days past due


    Try this


    =IF(N12-N13>90,"overdue",FALSE)


    Where N12 is the latest date, and N13 is the original date


    Alastair

    Einstein:
    Things should be made as simple as possible, but not any simpler


    Be sure to check out TemplateZone for all your Microsoft Office Needs.
    Get OfficeReady Professional 3.0 here!

  • Re: formula to figure out if 90 days past due


    Hi,


    I wasnt sure if you were to count working days (i.e. monday - friday), or just ALL days... here are two formulas you need anyway.


    'this is for caluclating working days between two dates
    =NETWORKDAYS(A1,TODAY())


    'this is for calulating all days (including Sat and Sun) between two dates.
    =DATEDIF(A1,NOW(),"D")


    NB - you might need to Add in the Analysis Toolpak to get the Networkdays function to work.


    You can then apply conditional formatting on the cell if more than 90 days.


    Ger

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________