text with a numeric funtion

[Desperate for Help]

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.

 

[Bernard Liengme]

This is how I would do it:
The validation list (popup menu) would have columns
Column 1 the text to use such as "Net 30 days"
Column 2 the number of days (eg 30)
Column 3 anyother data needed
Now when you select Net 30, a VLOOKUP would retrieve the 30 from column 2
and add it to invoice date
as in ="Due Date" & Text(Vlookup(....)+A1,"dd/mm/yy"), where A1 is the
Invoice date
Any help?

 

[Stephen]

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.