Hi Arvi

It helped (Do you know why?)

Thanks!


Hans


"Arvi Laanemets" wrote:

Hi

Try
=IF(OR(C38="",C38=38807),"",EOMONTH(C38,0))

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Hans" wrote in message
...
Hello

Im using the following formula for date calculation:

=IF(ISBLANK(C38),"",IF(C38=38807,"",(EOMONTH(C38,0 ))))

If C38 is blank or contains the date 31-mar-06 (38807) it returns a blank,
otherwise it should enter the last day of the month mentioned in C38.

It works OK if it refers to a real blank cell (with no formula) or to a
cell
that contains a date. However, when it refers to a cell that contains
above
formula (and returned a blank) I get a #VALUE error message. For example,
if
above formula would be in Cell C39 and would return a blank, i would get
an
error message if I copied the formula to Cell C40 (referring to Cell C39).

Does anyone know how to solve this? I want to copy this formula down
without
getting error message.

Thanks in advance.
Hans