EDATE does not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I found the neat little edate function in one of the forum answers, which is
exactly what I need. However, my formula:
=edate(A1,3)
does not work. I get #NAME. Problem is that the Analysis ToolPak appears
to be installed, as it does have a checkmark next to it. Here at work, the
systems people keep tight control over PC's. Users don't have any admin
rights. Otherwise, I would try to uncheck it and reinstall it.

Any ideas?
 
Don,

Thanks. That works for most dates. But I believe it is only subtracting
multiples of 30 days. I read in another post that the function is quirky.
If I do =DATE(YEAR(A2),MONTH(A2)-3,DAY(A2)) and my Start Date is 5/31/2006,
the formula returns 3/3/2006. EDATE does not have this limitation. I did
find elsewhere a VERY lONG formula that works, but its length makes it less
atractive.

I'm hoping someone has run into the edate issue and has a solution that will
make it work.
 
This seems to work

=TEXT(MONTH(A2)-3&"/"&DAY(A2)&"/"&YEAR(A2),"mm/dd/yyyy")

VBA Noo
 
Without using EDATE I believe this is the shortest formula that
replicates

=EDATE(A1,*3*)

=MIN(DATE(YEAR(A1),MONTH(A1)+*3*+{0,1},DAY(A1)*{1,0}))
 
VBA Noob,

Your formual gets confused in February. May 31 minus 3 months becomes
February 31. Thanks anyway.

daddylonglegs,
I would have never thought of this appraoch but it appears to work. And as
luck would have it, they sent out an install to our PC's yesterday for SP2
for Occie. Now edate works. Coincidnece? Hmmm. So I am going to use
edate, unless it decides to no logner work at soem point, but thanks to
everyone for their efforts.
 
Back
Top