Hello,

I have an issue with an inherited spread-sheet. I need to calculate months remaining between 2 dates but some of the dates aren't correctly formatted.

The values are, for example, 1/1/11. I have changed the format to date and tried to use the =DATEVALUE() formula but it just returns a VALUE error.

Any ideas?

Thanks in advance for any advice.