can you make EOMONTH work without Analysis ToolPak

P

ppidgursky

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

Teethless mama

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

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

T. Valko

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

Ron Rosenfeld

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.
Click to expand...

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
 
Top