Prev: Identifying the top five values in multiple groups
Next: Ctrl V paste coding was lost
From: d7 on 27 Apr 2010 09:17
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.



From: Jacob Skaria on 27 Apr 2010 09:33
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.
>
>
>
From: Glenn on 27 Apr 2010 09:41
Unless d7 really meant what he said in the first half of the post, which was
"end of month following". That would be this:

=DATE(YEAR(A1),MONTH(A1)+2,0)


Jacob Skaria wrote:
> Try
> =DATE(YEAR(A1),MONTH(A1)+2,1)
>

"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.
> >
> >
> >
From: Rick Rothstein on 27 Apr 2010 13:36
And if you are using XL2007 and above, or if you have the Analysis ToolPak
add-in selected for XL2003 or earlier, then you can use this formula...

=EOMONTH(A1,1)+1

Remove the "+1" part if you really meant end of the month and not first of
the month after the end of the month.

--
Rick (MVP - Excel)



"d7" <d7(a)discussions.microsoft.com> wrote in message
news:B3D774D5-982A-4566-8340-1F3335490DB8(a)microsoft.com...
> 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.
>
>
>
 | 
Pages: 1
Prev: Identifying the top five values in multiple groups
Next: Ctrl V paste coding was lost