Hello

Thanks for your explanation; makes things a bit more easier to understand.

Regards
Hans

"Hans" wrote:

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