1. On the worksheet a cell is formated as date.
In vb is a variable also formated as date
If I have variable = cell I get a formating error if the cell is empty
I can use isempty or isdate first to test the cell but seems like a pain

2. cell is formated as date like 01/01/09
If someone enters the date in the cell as 1/01/09 then get an error if
try to set the cell = variable formated as date.

In general I'm having trouble working with dates I guess. In the program
data is entered directly into the worksheet by the operator.

Thanks

John