I'm trying to return the name of the day of the week from a date but I keep getting a compilation error on the "ddddd" part of the statement...
Dim lWeekday As Long
Dim strWeekdayText As Long
lWeekday = WorksheetFunction.Weekday(("teTrainingDate" & Idx))
strWeekdayText = WorksheetFunction.Text(lWeekday, “ddddd”)
Any ideas ?