I don't want dates to be automatically populated until the cell is populated

Hi - I have a date column (Column D) that is blank but will be filled in with a Date of Birth (DOB) and then a number of columns for 3 months, 4 months, 6 months etc after the DOB. For example the formula I have for the 3 month column is =EDATE(D6,3)

As I have a 100 rows I copied and pasted this formula down the 3 month column. However, I have ended up with 31/3/1900 being inserted into all the cells.

I need to have the cells blank (but with the formula) until a date is put into Column D.

Any advice will be very gratefully received.

Thank you.

Try this ...

=IF(D6="","",EDATE(D6,3))

Many thanks to you MarvinP and Phuocam as your advice has worked and I'm very appreciative.