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

http://Get Plagiarism-Free and Quality Papers Without Overpaying at Homeworkmavens.com

http://Solution preview:

Just in case you need an assignment done, hire us. Using our writing services will make your life easier because we deliver exceptional results. Use us to get an A!

We are the Best!

course-preview

275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.


12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.


Double line spacing

Your essay will have double spaced text. View our sample essays.


Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.


We Accept

Secure Payment
Image 3

Subjects We Cover