Hi:
I have 1 spread sheet that has an expiration date entered on it. The
information from that sheet is fed into another sheet that calculates 9
months after the expiration date on the 1st sheet.
example

Sheet 1 Sheet 2

A B(expiration date) A
B(next contact date)
client name 3/5/10 same client name 12/5/10

The problem is on Sheet 2, because the column is formatted for date and
there is a link to sheet 1, it is showing up as 10/1/00, until an expiration
date is inserted in sheet 1. I've tried conditional formatting using the
number equivalent and making the font white to hide it - doesn't seem to work.

Any ideas would be greately appreciated. Thanks - Cindyt