I think there should be a simple solution to this, but I can't seem to find
the answer. I'm creating an order follow-up log where there are columns that
specify to follow up in a set number of days, based on order entry date. I
have copied the formula for 200 rows, but it returns "01/05/00" (for 5 days
after date of entry) when there is no entry in the referenced cell. (I
understand why) How can I make the cell return nothing (blank) when the
referenced cell is blank (no entry?)

Example:

Date of Order
Cell A1
Entry is 06/06/08

Follow up
Cell M1
Formula is =A1+5
Returns 06/11/08

When A1 is blank, formula returns 01/05/00
I would like it to return nothing.

Thank you!