Using Date and IF perhaps...

[Adam]

Hi

All of our company's mail needs to be monitored to ensure a prompt response
so I'm trying to create a mail monitoring spreadsheet. Column B is the date
received and Column J is the target date (five working days from date
received)

I entered =WORKDAY(B11,5) into column J and dragged downward only to find
06/01/1900 on every row. I'd like this removed and every column to remain
blank until a piece of mail is entered. How do I maintain keep cells "empty"
whilst maintaining the formula in the background?

I hope this makes sense!

Regards,

Adam

 

[Pete_UK]

Try this:

=IF(B11="","",WORKDAY(B11,5))

and copy down. Will display a blank if B11 is blank.

Hope this helps.

Pete