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