software

Help please I can not figure out a work around. I have a formula in excel
2002 that works fine.
=EDATE(AS14,-1)
When opened in 2003 it appears
#NAME?
I thought I could change this function to one in 2003 but I am still having
problems. I have tried =DATEVALUE(AR12) but this also gets me an error
unless the date is typed in.
Any assistance anyone could give would be much appreciated.
ThanksLoad the analysis toolpak (Tools gt; Add-Ins, select the Analysis Toolpak)

quot;Waynequot; wrote:

gt; Help please I can not figure out a work around. I have a formula in excel
gt; 2002 that works fine.
gt; =EDATE(AS14,-1)
gt; When opened in 2003 it appears
gt; #NAME?
gt; I thought I could change this function to one in 2003 but I am still having
gt; problems. I have tried =DATEVALUE(AR12) but this also gets me an error
gt; unless the date is typed in.
gt; Any assistance anyone could give would be much appreciated.
gt; Thanks
gt;

The EDATE function is part of the Analysis Tool Pack (ATP)
add-in, and you'll get a #NAME error if the ATP is not loaded. Go
to the Tools menu, choose Add-Ins, and check Analysis Tool Pak in
the list of add-ins. If it doesn't appear in the list, you'll
need to install it from your Office CD.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;Waynequot; gt; wrote in message
...
gt; Help please I can not figure out a work around. I have a
gt; formula in excel
gt; 2002 that works fine.
gt; =EDATE(AS14,-1)
gt; When opened in 2003 it appears
gt; #NAME?
gt; I thought I could change this function to one in 2003 but I am
gt; still having
gt; problems. I have tried =DATEVALUE(AR12) but this also gets me
gt; an error
gt; unless the date is typed in.
gt; Any assistance anyone could give would be much appreciated.
gt; Thanks
gt;
Thank you. I can not believe I missed that.

quot;bpeltzerquot; wrote:

gt; Load the analysis toolpak (Tools gt; Add-Ins, select the Analysis Toolpak)
gt;
gt; quot;Waynequot; wrote:
gt;
gt; gt; Help please I can not figure out a work around. I have a formula in excel
gt; gt; 2002 that works fine.
gt; gt; =EDATE(AS14,-1)
gt; gt; When opened in 2003 it appears
gt; gt; #NAME?
gt; gt; I thought I could change this function to one in 2003 but I am still having
gt; gt; problems. I have tried =DATEVALUE(AR12) but this also gets me an error
gt; gt; unless the date is typed in.
gt; gt; Any assistance anyone could give would be much appreciated.
gt; gt; Thanks
gt; gt;