Is weekday?

Hi! I have a small problem. In my Excel macro I want to check if a certain
date that exists in an array is a weekday (Saturday or Sunday). My
excel-version is in Swedish so I do not know how to do this in my VBA macro.
In Excel there is a function (in Swedish) that is like this =DATE(“a1”). It
returns a number depending on what day is entered in cell a1. That is what I
want to do in my macro. Please help me! Many thanks in advance!

=VECKODAG(A1;2)>5

shows TRUE if Sat or Sun

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" <ArneHegefors@discussions.microsoft.com> wrote in message
news:6C350B69-9FA7-457B-8DC3-78613C61C333@microsoft.com...
> Hi! I have a small problem. In my Excel macro I want to check if a certain
> date that exists in an array is a weekday (Saturday or Sunday). My
> excel-version is in Swedish so I do not know how to do this in my VBA
macro.
> In Excel there is a function (in Swedish) that is like this =DATE("a1").
It
> returns a number depending on what day is entered in cell a1. That is what
I
> want to do in my macro. Please help me! Many thanks in advance!