I am very new to xl and am trying to create invoices for my business. And on
these invoices I have a terms list showing "On Reciept, Net 30, and 2% 10
Net 30."
I also show a Invoice date and a due date.
I would like to to be able to type in my invoice date then choose from my
terms list and have it add the appropriate number to that date and show me my
due date. for example

Invoice Date
12/20/2007

Terms
Net 30 from pop down menu.. i have already built the pop down list. By
choosing Net 30 It adds 30 days to the above invoice date. With "On Receipt"
it will add 0 etc.

Due Date
01/19/2008


Is this possible? is it possible to have text with a numeric value.
P.s I don't know lingo so if you could explain it to me in very simple terms
that I can understand that would be great. Thank you for your help Ive been
working on trying to find the solution for about 4 hours now.