Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 17, 11:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2017
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

  #2   Report Post  
Old November 1st 17, 11:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2017
Posts: 2
Default CONDITIONAL FORMATTING BASED ON A DIFFERENCE IN DAYS BETWEEN TWO DATES

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - Given dates within certain range of days Tee51 Excel Worksheet Functions 6 February 22nd 13 02:13 AM
Difference Between Dates WITH Conditional Formatting DOUG Excel Worksheet Functions 2 May 18th 10 10:25 PM
conditional formatting dates to change if its more than 3 days go markwmansell Excel Worksheet Functions 6 November 16th 08 06:42 PM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux[_2_] Excel Worksheet Functions 2 October 11th 07 02:04 PM
Conditional Formatting - Difference between dates Gohan51D Excel Discussion (Misc queries) 5 March 14th 06 11:08 AM


All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017