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?