Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#NAME? error using EDATE
Hi All,
I have a situation where I upgraded a computer from Win98 to WinXP and now Excel 2000 files using EDATE for amortization schedule generates #NAME? error. For example: =EDATE(B14,1) generates #NAME? error where cell B14 has any date in it. This used to work before, but now doesn't work on other computers with Windows XP Pro and Excel 2000 either. Any ideas on how to solve this issue would be greatly appreciated. Thanks in advance. John Zimmermann |
#2
|
|||
|
|||
EDATE is in AnalysisPac. You need to install it (when installing Excel) and
load it with Tools | Addins best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Zimbob79" wrote in message ... Hi All, I have a situation where I upgraded a computer from Win98 to WinXP and now Excel 2000 files using EDATE for amortization schedule generates #NAME? error. For example: =EDATE(B14,1) generates #NAME? error where cell B14 has any date in it. This used to work before, but now doesn't work on other computers with Windows XP Pro and Excel 2000 either. Any ideas on how to solve this issue would be greatly appreciated. Thanks in advance. John Zimmermann |
#3
|
|||
|
|||
You need to have the Analysis ToolPak installed. Go to
Tools Add-Ins. Once installed, press F9. HTH Jason Atlanta, GA -----Original Message----- Hi All, I have a situation where I upgraded a computer from Win98 to WinXP and now Excel 2000 files using EDATE for amortization schedule generates #NAME? error. For example: =EDATE(B14,1) generates #NAME? error where cell B14 has any date in it. This used to work before, but now doesn't work on other computers with Windows XP Pro and Excel 2000 either. Any ideas on how to solve this issue would be greatly appreciated. Thanks in advance. John Zimmermann . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
EDATE &EOMONTH problem | Excel Worksheet Functions | |||
The Help on the Excel Edate worksheet function contains an error:. | Excel Worksheet Functions | |||
Edate problem | Excel Worksheet Functions |