Day Of Week

[#1]

Hi All

I have list boxes for Year and Month. I would now like to create one for "Day of Week" containing "Monday" to "Sunday" as values.

What function can I use for this?

[JonnyPoole]

There is a date mask to use.  'WWW' will return  Mon,Tue, Wed.   'WWWW' will return the full word Monday, Tuesday...

Pass the 'WWW' mask to the function date() to render a date in this format.

=Date(Date,'WWWW')

[jpapador]

DayName(DateField)

[MarcoWedel]

WeekDay()

[#5]

Hi Jonathan

Thanks for your answer. I have applied your method and now it shows a lot of random weekdays.

I would only like it to show Monday, Tuesday, Wednesday, Thursday, Friday, Saterday and Sunday.

[MarcoWedel · Accepted solution]

To get only one value per day of week in chronological order you could use:

=Dual(Date(Date,'WWWW'), WeekDay(Date))

[#7]

WeekDay returns an interger

[MarcoWedel]

Does it?