Hi All,

I am trying to have a formula that will calculate the due date on invoices that have payment terms "End of Month +30".

e.g. Invoice date May 7th, then the formule shoudl calculate 30 days from the end of May.

The invoice date is in the following format 07/05/2012.

I have been breaking my head over this. Please help.

Thanks.