excel macros formula expert needed asap

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

Don't use plagiarized sources. Get Your Custom Essay on
excel macros formula expert needed asap
Just from $13/Page
Order Essay

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

                                              .                                           ,.,.                                                              

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper