Analysis ToolPak Add-In

ad69iuu

New Member
Joined
Jan 28, 2005
Messages
7
I have put together a financial model for a client and his computer asks for the CD to install the analysis VBA toolpak in order to utilize the edate function. Does anyone know where to download this add-in in case the original CD is not found?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Not sure, but it might be available at microsoft.com. Also, maybe you can copy the add-in from your machine and give it to him. This sounds like the client has a challenged IT group.

lenze
 

Bob Rooney

Board Regular
Joined
Jul 25, 2006
Messages
169
Can you describe exactly how you are using the EDATE function in your model? EDATE has some quirks which you may or may not expect. By quirks I do not mean to say that they are bugs but rather some inconsistencies, especially around the end of months.

In cell A1, type 3/31/2006
In cell B1, type EDATE(A1,-2)

You should get 1/31/2006 after formatting as a date display

In cell A2, type =EDATE(A1,-1)
In cell A3, type =EDATE(A2,-1)

Results:
A2: 2/28/2006
A3: 1/28/2006

Change the formula in cell A3 to be =EDATE(A2,+1) and you should get 3/28/2006. Adding a net zero months parameter results in a three day difference.

EDATE is not calculating incorrectly. Rather, it gives some seemingly odd results that can be unexpected. There are alternatives that may be better and do not require either the Analysis Toolpak or VBA.
 

Forum statistics

Threads
1,141,027
Messages
5,703,818
Members
421,318
Latest member
cg_cartoonexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top