There are two ways you could do this
1. The simple way.
You could copy your dates to an additional column, select the new
column. Go to the "Format Menu" select "Cells", then select the
"Number" Tab and scroll to "Custom" and select. In the "Type" box,
input "DDDD" (for the weekday) or "DDDD, DD/MM/YYYY" (for the weekday
followed by the date) and then hit "OK".
2. The slightly less simple way.
Using VBA add a module to the spreadsheet and add this function to it
Function DayOfTheWeek(Dates)
DayOfTheWeek = Format(Dates, "DDDD")
End Function
Call the function from your spreadsheet as follows (assuming cell A1
has a date in) "=DayOfTheWeek(A1)"
The second method is better, if you want to combine the day of the week
with other strings.
--
TBee
------------------------------------------------------------------------
TBee's Profile:
http://www.excelforum.com/member.php...fo&userid=3557
View this thread:
http://www.excelforum.com/showthread...hreadid=457301