Hello again,

Is there a specific code to get the day of the week?
The value that should be returned is monday, tuesday etc.
I've got the Wrox programmer's reference, but I can't find it anywhere.

Thanks for the help,
Wim

I googled a bit by myself and found out that this should do:

range("A1").value = weekday(now()).

It doesn't return monday or tuesday but 2 and 3 instead.
To get the name of the week in full you can write in a cell

=text(now(),"dddd")

Dim NameOfDay As String
NameOfDay = WeekdayName(DatePart("w", Now))
MsgBox NameOfDay



DaveG

That was exactly what I was looking for!
thanks a lot,
Wim