Formula to work out the Invoice Due Date

Hi everyone,

I am trying to figure out what is the best formula to use enable to work out the purchase invoices due date. We have different agreed payment terms with different suppliers (i.e. 30 Days, 60 Days End of Month etc.). I would appreciate if someone could help me to identify the formula to work out the correct due date.



Please see the attached data sample and the list of the payment terms. There are two tabs on this file.


Many thanks.
Jean