how do I add days onto date

G

Guest

I have a coulumn called "Payment Terms"; this gives information such as 15
Days, 30 Days etc. Another coulumn is "Invoice Date". Thirdly, I have a
column called "Payment Date". I would like to add on 15 days or what ever the
column says to the "Invoice date" and then return the value to the "Payment
Date" column. Therefore, if the Invoice date was 2/09/2006 then the Payment
Date should be 17/09/2006. If it is difficult with the word "days" in it then
I would be happy to just have the number.
 
G

Guest

Hi

This works but I want the "Payment Date" field to add the days according to
what is in the "Payment Terms" - this would range from 14 days, 15 days, 20
days etc Please help!
 
D

Douglas J. Steele

We showed a constant 15 in the DateAdd statement, but you can put a
variable, or a table field there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Calculated Field in Query - Date Format 5
What formula do I need? 3
Expiration Date Automatic Update 1
How to add 30 days to date in another column, including Sat/Sun? 2
Calculated Date Field 1
Calculating Days Late 1
Days Outstanding in a Query 1

Top