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?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,992
Messages
5,545,375
Members
410,679
Latest member
rolandbianco
Top