I am trying to make a sheet that will auto populate the end of month date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but they
did not list what it was. Any help would be great.

The formula below is equivalent with EOMONTH function and it doesn't required
Analysis ToolPak add-ins

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


"ppidgursky" wrote:

I am trying to make a sheet that will auto populate the end of month date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but they
did not list what it was. Any help would be great.

See this:

http://www.dicks-blog.com/archives/2...-addin-part-2/

Biff

"ppidgursky" wrote in message
...
I am trying to make a sheet that will auto populate the end of month date.
I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but
they
did not list what it was. Any help would be great.

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

A1 = 1/1/2007

I need the EOM date of the previous month.

The basic idea works but needs to be tweaked for the specific requirements.

For the above:

=EOMONTH(A1,-1)
=DATE(YEAR(A1),MONTH(A1)-1+1,0)

Biff

"Teethless mama" wrote in message
...
The formula below is equivalent with EOMONTH function and it doesn't
required
Analysis ToolPak add-ins

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


"ppidgursky" wrote:

I am trying to make a sheet that will auto populate the end of month
date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but
they
did not list what it was. Any help would be great.

On Thu, 7 Jun 2007 14:58:00 -0700, ppidgursky
wrote:

I am trying to make a sheet that will auto populate the end of month date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but they
did not list what it was. Any help would be great.

I think this will work:

=DATE(YEAR(A1),MONTH(A1)+1+A2,0)

A1 is the "base date"
A2 is the number of months (positive or negative) as in the EOMONTH function.

e.g. =EOMONTH(A1,A2)


--ron

Well, that did it. I appreciate the help.
Thank You
Peter

"Ron Rosenfeld" wrote:

On Thu, 7 Jun 2007 14:58:00 -0700, ppidgursky
wrote:

I am trying to make a sheet that will auto populate the end of month date. I
found the "EOMONTH" and works great, but I need to dispurse this sheet to
many people who many different machines, and to have them try to add the
toolpak will be overwelmingly bad. I read someone had a work around but they
did not list what it was. Any help would be great.

I think this will work:

=DATE(YEAR(A1),MONTH(A1)+1+A2,0)

A1 is the "base date"
A2 is the number of months (positive or negative) as in the EOMONTH function.

e.g. =EOMONTH(A1,A2)


--ron

On Fri, 8 Jun 2007 09:17:01 -0700, ppidgursky
wrote:

Well, that did it. I appreciate the help.
Thank You
Peter

You're welcome. Glad to help. Thanks for the feedback.
--ron