How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
is given by "dddd" but I need the reverse process. I would be open to the
numbers of the Day of Week too.

I am given the:
mm=11
dd=15
yyyy=2009

find
dddd or number of the Day of Week

On Sun, 30 May 2010 14:26:01 -0700, sort
<(E-Mail Removed)> wrote:

>How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
>is given by "dddd" but I need the reverse process. I would be open to the
>numbers of the Day of Week too.
>
>I am given the:
>mm=11
>dd=15
>yyyy=2009
>
>find
>dddd or number of the Day of Week

The formula
=WEEKDAY(DATE(2009,11,15),2)
returns the value 7, indicating that November 15, 2009 was a Sunday.

Hope this helps / Lars-Åke

"Lars-Åke Aspelin" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> On Sun, 30 May 2010 14:26:01 -0700, sort
> <(E-Mail Removed)> wrote:
>
>>How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
>>is given by "dddd" but I need the reverse process. I would be open to the
>>numbers of the Day of Week too.
>>
>>I am given the:
>>mm=11
>>dd=15
>>yyyy=2009
>>
>>find
>>dddd or number of the Day of Week
>
> The formula
> =WEEKDAY(DATE(2009,11,15),2)
> returns the value 7, indicating that November 15, 2009 was a Sunday.
>
> Hope this helps / Lars-Åke
>


Or in VBA:
Dim mm as Integer, dd as Integer, yyyy as Integer, dddd as string
mm=11
dd=15
yyyy=2009
dddd = Format(DateSerial(yyyy, mm, dd), "dddd")

Helmut.

Additional options to the previous answer.

The following returns the day of the week for any date. (I have used today's
date in each of the examples)

On a worksheet:
=TEXT(TODAY(),"ddd")
or
=TEXT(TODAY(),"dddd")

In VBA
Dim DayOfWeek As String

DayOfWeek = Format(Date, "ddd")
MsgBox DayOfWeek

DayOfWeek = Format(Date, "dddd")
MsgBox DayOfWeek

--
Regards,

OssieMac


"sort" wrote:

> How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
> is given by "dddd" but I need the reverse process. I would be open to the
> numbers of the Day of Week too.
>
> I am given the:
> mm=11
> dd=15
> yyyy=2009
>
> find
> dddd or number of the Day of Week

=WEEKDAY(DATE(2009,11,15),2) would be perfect but I am looking for something
to put in a VBA program not in a cell.

Did you read Ossie's post?



"sort" <(E-Mail Removed)> wrote in message
news:13DB4AF8-B7A2-4BC0-9CEC-(E-Mail Removed)...
> =WEEKDAY(DATE(2009,11,15),2) would be perfect but I am looking for
> something
> to put in a VBA program not in a cell.

hi
if your given date is in A1, try this to put the weekday name in b1......
Sub xlcalcit()
Dim s As String
Dim d As String
s = [A1].Value
d = WeekdayName(Weekday(s))
[B1].Value = d
End Sub

"sort" wrote:

> How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
> is given by "dddd" but I need the reverse process. I would be open to the
> numbers of the Day of Week too.
>
> I am given the:
> mm=11
> dd=15
> yyyy=2009
>
> find
> dddd or number of the Day of Week

afterthought
the code i posted will work on any date, past, current or future.

regards
FSt1

"FSt1" wrote:

> hi
> if your given date is in A1, try this to put the weekday name in b1......
> Sub xlcalcit()
> Dim s As String
> Dim d As String
> s = [A1].Value
> d = WeekdayName(Weekday(s))
> [B1].Value = d
> End Sub
>
> "sort" wrote:
>
> > How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it
> > is given by "dddd" but I need the reverse process. I would be open to the
> > numbers of the Day of Week too.
> >
> > I am given the:
> > mm=11
> > dd=15
> > yyyy=2009
> >
> > find
> > dddd or number of the Day of Week