Formula to calculate an invoice term - 30 days nett monthly Hi I have an invoice

Question

Formula to calculate an invoice term - 30 days nett monthly

Hi

I have an invoice template that calculates a payment date from the invoice date based on certain criteria.

file is stored here - http://1drv.ms/1nLvN1d

Does anyone have any idea on what formula I can use?

Payment Terms Payment Calcs 30 Days from Invoice Date 30 30 Days End of Month Following 30 formula =EOMONTH(I1018,1) 45 Days from Invoice Date 45 60 Days from Invoice Date 60 90 Days from Invoice Date 90 Within 7 Days 7 Proforma 0 30 Days Net Monthly end of month after invoice + 30 days

Explanation / Answer

Change the bold part:

IF(E1188="30 Days Nett Monthly";EOMONTH(I1188;0)+F1188

to:

EOMONTH(I1188;1)

will give 30 for the months with 30 days and 31 for the others. (Feb will be also correct).

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.