1. Is the source field a number formatted as date, or a string?
2. What is the exact formula you use?
I have a spreadsheet that makes use of the EDATE function, which works fine in the UK.
If I send this file to a colleague in Asia or Norway for example, as soon as they recalculate, all cells turn to errors.
If they send file back, as soon as I recalculate the file, the errors clear.
Their PC's will be set up to display dates in local format and puntuation, which is what I suspect causes the error.
Any ideas how I can work around this, and create a spreadsheet that will work any where in the world?
What I need is to be able to take any date, and calculate the date that is x months less one day in the future
For example, if x = 12, then 15th March 2012 -> 14th March 2013, and 1st March 2012 -> 28th Feb 2013