Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
To get only one value per day of week in chronological order you could use:
=Dual(Date(Date,'WWWW'), WeekDay(Date))
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')
DayName(DateField)
WeekDay()
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.
To get only one value per day of week in chronological order you could use:
=Dual(Date(Date,'WWWW'), WeekDay(Date))
WeekDay returns an interger
Does it?