I have Excel 2004. Can anyone tell me how to hide the formula in a cell where I've set it up to calculate the date something is due, based on a cell where someone will enter a start date? The start date is blank until someone puts a date in there, and as a consequence my due date is coming up a negative date. I'd like to make that hidden.
EXAMPLE:
7/26/10 MONDAY TITLE OF PROJECT 7/12/10 (14 days prior to start date)
If there's no date in the first column, the date due reads: -1/15/04
Thanks!
EXAMPLE:
7/26/10 MONDAY TITLE OF PROJECT 7/12/10 (14 days prior to start date)
If there's no date in the first column, the date due reads: -1/15/04
Thanks!