Quote:
Originally Posted by Dorian74
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.
|
Hi,
Assuming you're using at least Excel 2007 and your date is in cell A2 you can use
=EOMONTH(A2,0)+30
Obviously, change the A2 for whichever cell your date is really in.
Hope that helps.
S.