Excel Macros Formula

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

 

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now