Excel macros formula expert needed asap
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
. ,.,.
Select your paper details and see how much our professional writing services will cost.
Our custom human-written papers from top essay writers are always free from plagiarism.
Your data and payment info stay secured every time you get our help from an essay writer.
Your money is safe with us. If your plans change, you can get it sent back to your card.
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Get instant answers to the questions that students ask most often.
See full FAQ