Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edate function Name error
Hi, hoping someone can help. I'm using an edate function =EDATE(AdjData!O4,
E47) and am getting the Name error. I do have the Analysis toolpak enabled. If I uncheck the toolpak and check it again - the date appears fine. the problem is that this doesn't stick and I have to do it each time I open my workbook that uses this formula. Does anyone know of an alternative function? Is there an explanation for why this doesn't stick? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edate function Name error
Hi!
Here's an alternative to Edate: A1 = starting date B1 = number of months (either negative or positive) =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) Biff "SharonP." wrote in message ... Hi, hoping someone can help. I'm using an edate function =EDATE(AdjData!O4, E47) and am getting the Name error. I do have the Analysis toolpak enabled. If I uncheck the toolpak and check it again - the date appears fine. the problem is that this doesn't stick and I have to do it each time I open my workbook that uses this formula. Does anyone know of an alternative function? Is there an explanation for why this doesn't stick? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why sometimes excel returns error just because function parameters are linked? | Excel Worksheet Functions | |||
Function giving error | Excel Discussion (Misc queries) | |||
Function giving Error | Excel Worksheet Functions | |||
Custom function returning VALUE error | Excel Discussion (Misc queries) | |||
Why do I get a #Name error when I use the DateDif function? | Excel Worksheet Functions |