Hi Clare,

I think you have the problem of cell formatting.

format your source cells as dates and result cell as general. I have tried
the formula given by Gary''s Student which works perfect with the above
formatting.

kindly check and click yes below, if it works
"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