I have a few excel macro formula input for my dates and a 1 slide ppt slide to support the dates. chat me up asap
FORMULA
Delivery Date- Column P
Requirement Date -Column – Column J
Make a new column Y and add the formulas
If delivery Date (column P) is less than Req date(column J)- Ontime(in green color)
If delivery date(column p) is equal to Req date (column J) – Ontime(in green color)
If delivery date is 1-10 days greater than Req date – within 10 days late( in yellow color)
If delivery date is 11-20 days greater than Req date – within 20 days late( in blue color)
If delivery date is 20-30 days greater than Req date – within 30 days late (in purple color)
If delivery date is more than 30 days greater than Req date -more than 30 days late( in red color)
If delivery date is blank – No delivery date ( in red color)
Then I will just need a chart similar to the attached made off the dates above with the different colors(stated) in the chart