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 |
Using Date and IF perhaps...
Try this:
=IF(B11="","",WORKDAY(B11,5)) and copy down. Will display a blank if B11 is blank. Hope this helps. Pete On Mar 31, 3:42*pm, Adam wrote: 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 |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com