JDB

Use an IF function around your current formula checking for a blank in the
cell that will eventually be filled out (In my example A1)

=IF(A1="","",A1+1)

(These are two double-quotes, "")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"JDB" wrote in message
...
I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is
also a formula that adds a day if certain conditions are met. When I copy
this formula down so that every cell has it, the cells on rows that
haven't
been used yet show as 01/01/1900 00:00. How do I show these as blank
cells -
the sheet is quite confusing otherwise!