back up tracking system while we change software

K

Ken

Hello,
Help

I'm looking to track material out for repair by the type
of service requested.
In cell (G:2) will be the type of service:

BCK = bench check = this will have a projected return
date (I:2)within three days of the repair order date (H:2)

REP = repaired = this will have a projected return date
(I:2) within 7 days of the repair order date (H:2)

OVH = overhaul = this will have a projected return date
(I:2) within 14 days of the repair order date.

With all this I would also like to include the warranty
schedule from the date of the service return date(J2)
BCK= no warranty
REP= 90 day warranty
OVH= 180 warranty

Any information/help is greatly appreciated
 
K

Ken

I forgot to include the importand part. This is the
formula in H:2 to calculate the warranty date J:2,

=DATE(YEAR(I2)+1,MONTH(I2),DAY(I2)-1 = 1 yr warranty
=DATE(YEAR(I2),MONTH(I2),DAY(I2)+90 = 90 day warranty
=DATE(YEAR(I2)+1,MONTH(I2),DAY(I2)+180 = 180 day warranty

The start to this is the date of the repair order in G:2.

************ My initial information ******************

I'm looking to track material out for repair by the type
of service requested in cell (G:2) will be the type of
service:

BCK = bench check = this will have a projected return
date (I:2)within three days of the repair order date (H:2)

REP = repaired = this will have a projected return date
(I:2) within 7 days of the repair order date (H:2)

OVH = overhaul = this will have a projected return date
(I:2) within 14 days of the repair order date.

With all this I would also like to include the warranty
schedule from the date of the service return date(J2)
BCK= no warranty
REP= 90 day warranty
OVH= 180 warranty


-----Original Message-----

=IF(G2="BCK",I2,IF(G2="REP",I2+90,IF(G2="OVH",I2+180)))



Vasant
Click to expand...
BCK = bench check = this will have a projected return
date (I:2)within three days of the repair order date (H:2)

REP = repaired = this will have a projected return date
(I:2) within 7 days of the repair order date (H:2)

OVH = overhaul = this will have a projected return date
(I:2) within 14 days of the repair order date.

With all this I would also like to include the warranty
schedule from the date of the service return date(J2)
BCK= no warranty
REP= 90 day warranty
OVH= 180 warranty

Any information/help is greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date track based on svc cond. - open RO's 0
date tracking -* 4
Synchronization problems while moving folders to new email 1
Key Card Software (Auric) 7
Excel 2007 and Security key cards 3
Excel VBS time difference functions<[email protected] 0
Set up a time line tracking schedule 2
Combine Advanced Filter with a loop? 5

Top