View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
 
Posts: 287
Default Using Date and IF perhaps...

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