Try
=DATE(YEAR(A1),MONTH(A1)+2,1)

--
Jacob (MVP - Excel)


"d7" wrote:

Hi I need a couple of date formulas for invoices recieved, eg. invoice date
is 14/03/2010, payment terms are end of month following. so i need excel to
calculate that the due date is in this case 1/05/2010 is the due date.