HELLO,
I HAVE AN EXCEL FILE THAT SHOWS MY OPEN ORDERS BY DATE ENTERED.
ALL ORDERS HAVE A 62 DAY LEAD TIME.
THE SUPPLIER GIVES US A DATE THEY "EXPECT" TO FULFILL/SHIP OUR ORDER. THIS MAY BE BEFORE OR AFTER OUR DUE DATE.
I NEED TO CALCULATE ORDERS THAT WILL BE PAST DUE AND ORDERS THAT ARE SIMPLY STILL OPEN.

I HAVE MANAGED TO CALCULATE A FORMULA THAT = OUR ORDER DATE + 62 DAYS TO GIVE ME THE DUE DATE.....
((((YEAH ME!)))))

NOW I NEED TO TAKE THE DATE IN THAT COLUMN (DUE DATE) AND CHECK IT AGAINST THE DATES IN THE SUPPLIER'S EXPECTED SHIP DATE AND CREATE A CELL THAT TELLS ME IF IT IS PAST DUE OR OPEN.
C15 IS MY DUE DATE. =DATE(YEAR(B15),MONTH(B15),DAY(B15)+62) AND K15 US THE SUPPLIERS ESTIMATED SHIP DATE. COLUMN L15 NEEDS TO TELL ME IF THE ORDER IS "PAST DUE" OR SIMPLY "OPEN"

HELP WITH THIS CONDITIONAL FORMATTING FORMULA?
THANK YOU IN ADVANCE.
:)
GDOG

On Wednesday, November 1, 2017 at 5:43:08 PM UTC-5, wrote:
HELLO,
I HAVE AN EXCEL FILE THAT SHOWS MY OPEN ORDERS BY DATE ENTERED.
ALL ORDERS HAVE A 62 DAY LEAD TIME.
THE SUPPLIER GIVES US A DATE THEY "EXPECT" TO FULFILL/SHIP OUR ORDER. THIS MAY BE BEFORE OR AFTER OUR DUE DATE.
I NEED TO CALCULATE ORDERS THAT WILL BE PAST DUE AND ORDERS THAT ARE SIMPLY STILL OPEN.

I HAVE MANAGED TO CALCULATE A FORMULA THAT = OUR ORDER DATE + 62 DAYS TO GIVE ME THE DUE DATE.....
((((YEAH ME!)))))

NOW I NEED TO TAKE THE DATE IN THAT COLUMN (DUE DATE) AND CHECK IT AGAINST THE DATES IN THE SUPPLIER'S EXPECTED SHIP DATE AND CREATE A CELL THAT TELLS ME IF IT IS PAST DUE OR OPEN.
C15 IS MY DUE DATE. =DATE(YEAR(B15),MONTH(B15),DAY(B15)+62) AND K15 IS THE SUPPLIERS ESTIMATED SHIP DATE. COLUMN L15 NEEDS TO TELL ME IF THE ORDER IS "PAST DUE" OR SIMPLY "OPEN"

HELP WITH THIS CONDITIONAL FORMATTING FORMULA?
THANK YOU IN ADVANCE.
:)
GDOG

I SHOULD MENTION, IF THE DIFFERENCE BETWEEN THE DUE DATE AND THE EXPECTED SHIP DATE IS GREATER THAN 62 DAYS IT IS "PAST DUE".THANKS AGAIN! :)