Formula results giving 29/01/1990?

Hi,

I have a very basic spreadsheet, in it are 4 columns:

Name of a member of staff
The date of the member of staff's first day off
The date of the last day off
The date which they need to return a form (29 days after the last holiday day)

I have created the formula in the last column to work out the return form date, the formula is:

For example: =C2+29

This gives me back the date correctly. However, the spreadsheet also contains empty rows where staff have not yet taken a holiday. When copying the formula down the last column, staff who have not taken days off have a return form date of 29/01/1900.

Is there a way to get Excel to only activate the formula (for want of a better phrase) to only work out the due date when figures are put into the other staff's rows?

I've attached the sheet for a better example of my meaning.

Thanks.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.