Hi,

A1 has a date of 03/10/07

B2 has formula =A1 + 7

I want to copy that formula down the column B2 but if

B3 is empty I get 01/07/1900

How Do I make so that if there's no date entered in

A column I get blank cells but still retain formulas,

I've been running into this issue with other formulas but I couldn't find any solution searching this forum,

How do you call this type of problem ?

Thanks!

A1 has a date of 03/10/07

B2 has formula =A1 + 7

I want to copy that formula down the column B2 but if

B3 is empty I get 01/07/1900

How Do I make so that if there's no date entered in

A column I get blank cells but still retain formulas,

I've been running into this issue with other formulas but I couldn't find any solution searching this forum,

How do you call this type of problem ?

Thanks!

## Comment