Thread
:
formula from Excel97 doesn't work in Excel2003,any ideas why?
View Single Post
#
7
Don Guillett
Posts: n/a
Thanks for the kudos, but It doesn't take perfect to f1select indextype in
edate. What did you try?
--
Don Guillett
SalesAid Software
"nic" wrote in message
...
actually I did try the help first but I couldn't find the answer so posted
here
we obviously can't all be as perfect as you
"Don Guillett" wrote:
You didn't try help first, did you?
EDATE
See Also
Returns the serial number that represents the date that is the indicated
number of months before or after a specified date (the start_date). Use
EDATE to calculate maturity dates or due dates that fall on the same day
of
the month as the date of issue.
If this function is not available, and returns the #NAME? error, install
and
load the Analysis ToolPak add-in.
How?
--
Don Guillett
SalesAid Software
"nic" wrote in message
...
The formula I'm using is
=IF(C3="","",EDATE(C3,(D3*6)))
and instead of producing the required date its giving me a #name?
error
this worked absolutely fine in Excel97 but not in Excel2003 and I
can't
work
out why
Has anyone got any ideas?
Reply With Quote