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?
|