On Wed, 20 Feb 2008 05:27:01 -0800, SalD
wrote:

Hi,

I use the EDATE function a lot. My setting are set to 'Automatic
Calculation' and Analysis toll pack is also added in. However, when i open
files with the EDATE function used, the relevant cell returns the #NA result.
Any ideas why this might happen and how I can get a permanenet solution?

Thanks

Post your formula and it's precedents.

I'll guess there is a problem with your data.

Also, what version of Excel???
--ron