i need help with a formula to determine number of days between 2 dates to
determine % amount, paid less than 7 days before due = 0% discount, paid 7
-13 before due = 3% discount etc etc
column 3 column 4
column 5 column 6
date paid date due
amount due discount

I am new to this so any help will be usefull, thanks

=E15*LOOKUP(D15-C15,{0,7,13},{0,0.03,0.05})

adjust the arrays, {...}, to suit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Giac" wrote in message
...
i need help with a formula to determine number of days between 2 dates to
determine % amount, paid less than 7 days before due = 0% discount, paid 7
-13 before due = 3% discount etc etc
column 3 column 4
column 5 column 6
date paid date due
amount due discount

I am new to this so any help will be usefull, thanks

Thankyou Bob, you solved my problem, after a few tweaks ;)

"Bob Phillips" wrote:

=E15*LOOKUP(D15-C15,{0,7,13},{0,0.03,0.05})

adjust the arrays, {...}, to suit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Giac" wrote in message
...
i need help with a formula to determine number of days between 2 dates to
determine % amount, paid less than 7 days before due = 0% discount, paid 7
-13 before due = 3% discount etc etc
column 3 column 4
column 5 column 6
date paid date due
amount due discount

I am new to this so any help will be usefull, thanks