warranty

1. I need help in formula for tracking warranty validity based on shipping date and or sold date

Hello Everyone! I'm hoping that I can get some help with a formula on a spreadsheet I've been asked to work on. We manufacture and sell industrial equipment imported from other country which has either 12 months warranty from shipping date for our customers to sell. So once its sold - warranty...
2. Auto Fill Cells with Specific Date from a Different Worksheet

Hello, I recently took over a position at my work and I am working with a file that was not originally mine. I have warranty registration cards that we receive from our dealers once the item is sold to the end user. When the end user reports a failure they are supposed to submit a credit form...
3. Conditional Formatting on Cell that is outside the 365 days warranty end date

I am trying to set some conditional formatting on cell that are outside the 365 days warranty end date that is entered into the cell. <colgroup><col></colgroup><tbody> <colgroup><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> 19/07/2019 Within warranty 30/11/2018 Highlighted...
4. Weighted average to calculate monthly payments

Hi, I am pricing 2 extended warranty agreements. The warranties have a upfront price but the customer wants to pay for each warranty as monthly payment over 3 years/36 months. Extended Warranty A; qty 700; \$2,000.00 Extended Warranty B; qty 30; \$2,100.00 Because the warranties have...
5. Formula help with tracking warranty

Hi all, I'm hoping that I can get some help with a formula on a spreadsheet. I'm creating an excel that tracks return products base on the serial number. Here is the layout of the spreadsheet. Sheet 1: Serial Number A = Customer Name B = Brand C = Products Code D = Serial Number E = Date Sold...
6. VLOOKUP with Multiple Criteria (Checkbox and Text)

I have the following tick boxes: "New" in Cell B18, "Used" in C18 and "Refurbished" in D18. I have a "Make" which would just be text entered i.e. "Mitsubishi", "Toyota" etc in B22. If the "New" checkbox is ticked in B18 and a Make is entered into B22, I want it to do a VLOOKUP to my...
7. How can I create a Query from a table with multiple order types and reference numbers

Hi, I have a table that I access through ODBC. I can not edit or modify this table in any way. This table has multiple order types. Some order types have a reference id back to another order type. I would like to get the actual order number for those reference id's. I hope this makes sense. Here...
8. How to get a date formula based on several criteria

Hi all, Based on a warranty date, I would like to Set a Date and Time Date should be at least 2 days before the warranty expiration date. If warranty date is a Monday, date should be at least Wednesday from previous week @ 10 am or 2 pm Days must only be Monday, Tuesday, Wednesday Time...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back