Which option do i need to install? Analysis ToolPak. I can see another 7
options?
Thanks,
jose

"David Biddulph" wrote:

Did you read the bit of Mike's message where he said:
"This requires the analysis addin so Tools|addins and check it" ?
--
David Biddulph

"Joe" wrote in message
...
....
I have tried your formula but i get #Name? error

"Mike H" wrote:

Joe,

With the date the invoice is raised in A1 put this in another cell

=EOMONTH(A1,0)+30 Format as date

This requires the analysis addin so Tools|addins and check it and it will
return a date 30 days from the end of the month the invoice was created.

"Joe" wrote:

Hi there. I would like to create a formula that calculates the days
that the
invoice is outstanding. Now I have
=Today()
Date invoice plus 30 days
However, the 30 days should count after the end of the month of when
the
invoice is raised. Any ideas? Thanks

Yes. Analysis ToolPak.

If you had looked up EOMONTH in Excel's help, it would have told you:
"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."
(and given you a "How?" link in case you didn't know how).

I don't want to give an "RTFM" answer to every post in this group, but a
large proportion of the answers can be found in Excel's help. It's always
worth trying there first, then asking here if you don't understand. There
is a lot of useful advice at http://www.cpearson.com/excel/newposte.htm
--
David Biddulph

"Joe" wrote in message
...
Which option do i need to install? Analysis ToolPak. I can see another 7
options?
Thanks,
jose

"David Biddulph" wrote:

Did you read the bit of Mike's message where he said:
"This requires the analysis addin so Tools|addins and check it" ?

"Joe" wrote in message
...
....
I have tried your formula but i get #Name? error

"Mike H" wrote:

Joe,

With the date the invoice is raised in A1 put this in another cell

=EOMONTH(A1,0)+30 Format as date

This requires the analysis addin so Tools|addins and check it and it
will
return a date 30 days from the end of the month the invoice was
created.

"Joe" wrote:

Hi there. I would like to create a formula that calculates the days
that the
invoice is outstanding. Now I have
=Today()
Date invoice plus 30 days
However, the 30 days should count after the end of the month of when
the
invoice is raised. Any ideas? Thanks