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
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" schrieb im Newsbeitrag
...
On Sun, 30 May 2010 14:26:01 -0700, 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

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" wrote in message
...
=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