I'm not sure about your "2% 10 Net 30" bit. Do you have just three
alternatives for your terms, of which "On receipt" adds 0 days and the other
two add 30 days? If so, let's say the invoice date is in A1 and the terms
(from your drop-down list) in B1. In the due date cell you could use a
formula such as
=A1+IF(B1="On receipt",0,30)
(You need to format both date cells with a suitable date format.)
We could extend this if there are further alternatives. Post back with
details if you need more help.

"Desperate for Help" <Desperate for wrote in
message ...
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.