It is working after I uncheck the missing reference. Thanks for your help.

"Joel" wrote:

Jaob is right

It has the following format

DateAdd("m", 1, "31-Jan-95")

YOu may have a conflit if the Reference is added. Try unchecking the
reference, press OK and try again. You may have to exit excel and re-enter
to remove the reference.

"Jacob Skaria" wrote:

DateAdd is a VBA function and not a function within ATP. Check out help on
DATEADD()

DateAdd(interval, number, date)

If this post helps click Yes
---------------
Jacob Skaria


"John P" wrote:

Hi. I have been trying to use the Dateadd function but a dialog box pops up
saying can't find project or library and missing ATPVBAEN.XLA

Following instructions from some of the forums, I clicked the Microsoft
Office button and went to the add-ins and loaded in the Analysis Toolpak and
Analysis Toolpak-VBA (atpvbaen.xlam). But the problem still persists.

In my VBE, the Tools/References dialog still shows missing ATPVBAEN.XLA. In
searching for this file, I found these 4 files in Office12/library/analysis:
Analy32 (blue square), atpvbaen (red square), funcres (red square) and procdb
(red square). Can anyone advise me what's wrong? Thank you for your advice.