karlo16
04-02-2009, 06:45 PM
Hi...
First of all thanks ahead of time for your help!
version: Excel 2003
I'm trying to create a spreadsheet to keep track incoming information. It will be added to daily by myself and others. The main purpose of the spreadsheet is to keep track of a due date that is 180 days from the date that a court order is filed. I have a formula in column C which automatically calculates a due date, which is 180 days from whatever date is entered into column B.
Here's the formula I'm using: =DATE(YEAR(B6),MONTH(B6),DAY(B6)+180)
The problem is that even if nothing is entered into column B, a due date (6/28/1900 - which I'm assuming is 180 days from 1/1/1900) automatically appears in column C. I want column C to be blank (but still contain the formula) so that it doesn't confuse the other people who will be entering info into this spreadsheet. I'd also like to be able to protect the formula in column C from accidental deletion...
Can anyone tell me what I'm doing wrong? As much detail as possible will be appreciated, as I'm still kind of a novice when it comes to creating spreadsheets.
I've attached an example of what I'm talking about...
Thank you so much for any help you can offer!
Karl
First of all thanks ahead of time for your help!
version: Excel 2003
I'm trying to create a spreadsheet to keep track incoming information. It will be added to daily by myself and others. The main purpose of the spreadsheet is to keep track of a due date that is 180 days from the date that a court order is filed. I have a formula in column C which automatically calculates a due date, which is 180 days from whatever date is entered into column B.
Here's the formula I'm using: =DATE(YEAR(B6),MONTH(B6),DAY(B6)+180)
The problem is that even if nothing is entered into column B, a due date (6/28/1900 - which I'm assuming is 180 days from 1/1/1900) automatically appears in column C. I want column C to be blank (but still contain the formula) so that it doesn't confuse the other people who will be entering info into this spreadsheet. I'd also like to be able to protect the formula in column C from accidental deletion...
Can anyone tell me what I'm doing wrong? As much detail as possible will be appreciated, as I'm still kind of a novice when it comes to creating spreadsheets.
I've attached an example of what I'm talking about...
Thank you so much for any help you can offer!
Karl