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?

EDATE is in the Analysis Toolpak. You need to go to Tools|Add-Ins and Check
the analysis Toolpack. You may have to recalculate the sheet.
Try Selecting the whole sheet and then pressing F9.

tj

"nic" wrote:

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?

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?

brilliant
thanks for your help

"tjtjjtjt" wrote:

EDATE is in the Analysis Toolpak. You need to go to Tools|Add-Ins and Check
the analysis Toolpack. You may have to recalculate the sheet.
Try Selecting the whole sheet and then pressing F9.

tj

"nic" wrote:

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?

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?

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

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?