Try this:

=IF(OR(V4="",U4=""),"",V4-U4)

This will give a blank if either of the dates are missing. If you want
a zero, just change the third "" (in the middle of the formula) to 0.

Hope this helps.

Pete

On Aug 28, 3:01*pm, Clare wrote:
Hi
Could you tell me how to get zero or blank with this formula:-

=(V4-U4) both columns are dates but if there is no date in column V4 then it
shows -38694 could you tell me what formula I need to put in to make this
show as zero or blank if there is no date in V4.

Thanks
--
Clare