Excel Macros Formula Expert

Excel Macros Formula Expert

topic : Excel Macros Formula Expert

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

Enlightening assignments are the elementary merit of students to achieve the specified task with immense ability. Worldwide educational teachers give assignments to students to put into effect. These online services do not let you just sit back and relax because these websites are a valuable tool to overcome their weaknesses. In this fast world, people with strong personalities, alert and thoughtful minds are valued.
Assignments Proficient is a website where students from across the globe come under one roof to gain purposeful assignments. Globally, the education is still in its young stage where taking help by any means outside the educational institutes is infrequent. So we have separate forums to examine the variety of subject areas. Within each forum, there is ranking allotted to the person who is most efficient to do the assignment in the best possible way. If you are a student in Dubai or travelling here for your education, then we are the pillars of strength, whom you can trust and ladder of support, for any assistance in your assignment.

 

Do you have a similar assignment that you would wish our expert writers to handle for you? Place an order with us on   assignmentsproficient.com and expect the best grades and help from qualified writers

 

 

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"