Cells showing unwanted information...
I am setting up a control sheet for monitoring visits. I have it set that
when you put in a consumer's start date, it automatically fills in the date
the first visit should be made and so on. My problem is that if I leave a
space blank, it fills in a date from 1900. I know I can use conditional
formatting or something to solve this, I just can't figure it out. Can
someone please help?
|