I am trying to compare dates between 2 columns in Excel. The 1st column is when a device makes it to the repair shop, the 2nd column in my comparison is the date the device left the shop. I have a SLA(Service Level Agreement) of 3 business day. I am looking to highlight the listings that go out on time with a green return date, and red if it is late.
If the comparison could consider business days as well that would be sweet!
Please attach a copy of your workbook so we can test solutions on your data. Remember to remove/replace any sensitive data before uploading.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Sorry for the delay. I have attached my spreadsheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks