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 will be valid again for 12 months from sold date. I want to show in one column of the status of warranty as DISQUALIFIED or VALID
Can it be done so that when ever a sold date or shipping date is entered it will automatically show the status on Column F? Can it then be set so that the time remaining is then automatically shown in Col. G as an upto date and current
Layout of sheet is as follows:
A = Customer Name
B = Country
C = Serial number
D = Shipped Date
E = Sold date
F = Status
G= Warranty time left
If this is hard way of doing this then i'am open to any suggestions for better and / or easier ways.
Appreciate assistance! Many Thanks!
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 will be valid again for 12 months from sold date. I want to show in one column of the status of warranty as DISQUALIFIED or VALID
Can it be done so that when ever a sold date or shipping date is entered it will automatically show the status on Column F? Can it then be set so that the time remaining is then automatically shown in Col. G as an upto date and current
Layout of sheet is as follows:
A = Customer Name
B = Country
C = Serial number
D = Shipped Date
E = Sold date
F = Status
G= Warranty time left
If this is hard way of doing this then i'am open to any suggestions for better and / or easier ways.
Appreciate assistance! Many Thanks!