Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changes in date functions between excel 2002 and 2003
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. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changes in date functions between excel 2002 and 2003
Load the analysis toolpak (Tools Add-Ins, select the Analysis Toolpak)
"Wayne" wrote: 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. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changes in date functions between excel 2002 and 2003
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 "Wayne" wrote in message ... 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. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changes in date functions between excel 2002 and 2003
Thank you. I can not believe I missed that.
"bpeltzer" wrote: Load the analysis toolpak (Tools Add-Ins, select the Analysis Toolpak) "Wayne" wrote: 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. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying charts from excel 2003 in excel 2002? | Excel Discussion (Misc queries) | |||
Excel 2003 formats different that excel 2002 | Excel Discussion (Misc queries) | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) |