Posts by sinac

    Hello,
    I have a problem of finding this formula,:confused:
    I eloborate my question to 3 parts:-


    1. I want to compare between Date1 and Date2 which one is the latest,
    2. Lets say Date2 is the latest,then i want to compare it with Date3 wether
    the length between Date2 & Date3 was 5 days.
    3. If the length less or equal to 5days, it will write '1' to colum A
    and if more than 5days ,it will write '1' to colum B


    example:
    --Date1---------Date2---------Date3--------------A-------B
    12/10/2006----11/10/2006---16/10/2006-----1-------
    17/10/2006----10/10/2006---22/10/2006----- -------1


    can anybody help me..please


    Regards;
    Hisham:)