Ron,

The suggestion you gave me produced the same error. To be absolutely sure
there is nothing wrong with the dates I deleted Cell A1 contents, formatted
the cell as a date (again) and entered the date "1/11/06" no quotes. Using
the formula =eomonth(a1,1) still returned a #value! error instead of what I
expected 30/12/06.

"Ron Rosenfeld" wrote:

On Sat, 11 Nov 2006 12:02:01 -0800, Mike
wrote:

i have dates in a column and in the next column im using the formula
=eomonth(a1,1) and instead of getting the last day of the next month I'm
getting a "#value!" error despite being fairly sure the formula is correct.
Any suggestions?

Mike


The VALUE error frequently indicates a problem with your *data*.

Could it be that you have imported the date from an HTML or other web source?
If so, it is probably text with a trailing <no break space character.

Try this:

=EOMONTH(SUBSTITUTE(TRIM(A1),CHAR(160),""),1)


--ron