use the isdate() function

eg
If isdate(example) then
ExampleTrue = DateValue(Example)
else
msgbox example & " is not a valid date"
end if



Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I heve got variable with name Example, its text. I use
this varible for
entry date.
Then I used: for getting true date. When
Example is = 5/7/03 then ExampleTrue = 5.7.2003, but
when Example is only
=5/ its Error. So how can I checked if Example is good
entry: dd.mm.yy

Tom


.