EDate() is a special function which is part of the Analysis ToolPak, and which you need to make sure that it is installed for that function to work
If you need help in installing the Analysis ToolPak let me know which version of Excel you are running
I knew about Analysis Tool pack. I realise the snag is that I have recently had to replace my computer so the old Excel settings have gone. I get a message about trying an alternate path to PRO11.MSI which I don't have. Any ideas?
That is really another matter which had not been mentioned. I will be happy to look into it but I feel that I have answered your initial question for which I should get credit
I have checked that issue and I can confirm that it is totally unrelated to your initial EDATE() question which I have answered. So you need to apply rating for the first question and create a new ticket for the new issue. But I will nevertheless help you with this after the rating. You will have a chance to add bonus later
I told you I had been using it for years - 10 or so- so did not need the advice about how to instal. My problem is that the installed addin no longer works......