Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
update week to week in excel. | Excel Worksheet Functions | |||
update week to week in excel. | Excel Worksheet Functions | |||
How do I change from a 7 day week to a 5 day week in Excel? | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) |