A
akemeny
I have a very elaborate spreadsheet that is used by most of the people in my
office. I have three columns that contain formulas that calculate 30, 60 &
120 days from the date keyed into a specific column (ie: =bk2+30). Before a
date is entered into [bk2] the date that is displayed is a standard date
1/30/00. I know that you can hide anything that has a zero in that column,
but how do you hide that date until an actual date is keyed into [bk2]? Is
that even possible?
office. I have three columns that contain formulas that calculate 30, 60 &
120 days from the date keyed into a specific column (ie: =bk2+30). Before a
date is entered into [bk2] the date that is displayed is a standard date
1/30/00. I know that you can hide anything that has a zero in that column,
but how do you hide that date until an actual date is keyed into [bk2]? Is
that even possible?