Bob already advised you as to the problem with having your value as an
integer. Just to add, you can use the Value2 property to get the dateserial
as a number rather than a date (although it should be converted just through
the assignment to a long or double).

--
Regards,
Tom Ogilvy

"Peter B" wrote in message
...
The date cell is formatted as Date yes (in Excel). In that cells is todays
date, by using the formula =Today(). I have declared Startdato as an Integer
(DIM startdato as Integer).

Rgds,

Peter B