can you make EOMONTH work without Analysis ToolPak
 

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.

can you make EOMONTH work without Analysis ToolPak
 

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.

can you make EOMONTH work without Analysis ToolPak
 

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.

can you make EOMONTH work without Analysis ToolPak
 

=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.

can you make EOMONTH work without Analysis ToolPak
 

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

can you make EOMONTH work without Analysis ToolPak
 

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

can you make EOMONTH work without Analysis ToolPak
 

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