Do you have your own UDF called EOMONTH?
What happens if you press F5 and fill in EOMONTH ?
What happens if you use the Insert Function Wizard *in an empty cell* to insert EoMonth?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Mike" wrote in message ...
| Ron,
|
| =len(A1) returns 5
| =istext(a1) returns false
|
| I suspect that this confirms that it is in fact a date am I correct?
| Thanks for your perseverance.
|
| Mike
|
| "Ron Rosenfeld" wrote:
|
| On Sat, 11 Nov 2006 12:43:02 -0800, Mike
| wrote:
|
| 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.
|
| I cannot reproduce the problem you report on my system. But I would expect to
| get 31/12/06 as a result (which I do).
|
| What are your Language settings?
| (I tried English-GB to get the DMY format)
|
| What are the return values for these formulas:
|
| =LEN(A1)
|
| =ISTEXT(A1)
|
| =EOMONTH(DATE(2006,11,1),1)
|
| They should return
|
| 5
| FALSE
| 31 DEC 2006 (depending on format)
|
|
| --ron
|