View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] skorkamgina@gmail.com is offline
external usenet poster
 
Posts: 2
Default CONDITIONAL FORMATTING BASED ON A DIFFERENCE IN DAYS BETWEEN TWO DATES

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