I have a drop down list of a few types of warranties in a defined name Warranty. Of these, I am trying to calculate the number of days warranty work should be completed. I have multiple warranties, but only 3 variales in turn around days. So WR9011 WR9012 WR9013 would be a 1 day turnaround. and so on. when one of these is selcted in the drop down, I need a due date to be calculated from the enterd date in B1...

Date recvd=B1 Warranty DropList=G1 Due Date=H1


Hope this is enough for now, thanks very much in advance...