Day of the Week in Excel
 

If I have a certain date in a field, say June 12, 2008, is there anyway to
do something that will tell me what day of the week that was.

Day of the Week in Excel
 

Hi,

You posted in programming so do you want

r = Format(Weekday(Range("A1").Value), "dddd")

or on the worksheet

=weekday(a1)

forma as dddd

Mike

"Kat5813" wrote:

If I have a certain date in a field, say June 12, 2008, is there anyway to
do something that will tell me what day of the week that was.

Day of the Week in Excel
 

Thursday:

Sub YouWhereThere()
s = DateValue("June 12 2008")
MsgBox (Format(s, "dddd"))
End Sub

--
Gary''s Student - gsnu200832


"Kat5813" wrote:

If I have a certain date in a field, say June 12, 2008, is there anyway to
do something that will tell me what day of the week that was.