calculating payment terms "End of Month +30".

[Dorian74]

Hi All,

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

e.g. Invoice date May 7th, then the formule shoudl calculate 30 day
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

 

[Spencer101]

Hi All,

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

e.g. Invoice date May 7th, then the formule shoudl calculate 30 day
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.

Hi,

Assuming you're using at least Excel 2007 and your date is in cell A
you can use *=EOMONTH(A2,0)+30*

Obviously, change the A2 for whichever cell your date is really in.

Hope that helps.

S