I would assume that your data contains many different reps with terms.

I would probably start with use the choose funtion.

CHOOSE(index_num,value1,value2,...)

Make a table that equates each rep with with set of terms (make these a
number so they can go dieectly into the Choose funtion).

You can than do something like Choose(Vlookup(Rep,TermsTable,2,false) to get
a number 1-whatever representing each set of terms,

You can then put formulas to get you date for each type.

If this helps, please remember to click yes.


"Hendee70" wrote:

It must be early monday morning because I can not wrap my head around this.

I have a spreadsheet that has due dates and pay dates that are different
depending on sales rep. This is an example:

A B C D E
1 customer sales rep inv date due date pay date
2 misc 1 SLS 11/30/2009
3 misc 2 HOU 11/30/2009
4 misc 3 NAG 11/30/2009
5 misc 4 KAS 11/30/2009



Sales Rep SLS always gets paid on the first of the month following the
invoice date.
Sales Rep NAG always gets paid on the 15th if in by the 30th and paid by the
30th if in by the 15th.
Sales Rep KAS and HOU is net due 30 days.

Can anyone help?