Excel Macros Formula

/in /by

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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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