Returning Day of Week based on Date

[winstein]

The DayOfWeek function found in the Macro Scheduler only allows the return of today's day of the week, from what I see. Is there any way to look at a certain date and return that day's day of the week?

Thanks for reading.

[hagchr]

Hi, try the following (where the second argument, 2, says that first day of week is Monday. You can select any weekday as start of week)

VBEval>Weekday("2014-07-21",2),res

MessageModal>res
  View Snippet Page

[hagchr]

In case it was not clear, when you set Monday as start of week then, the the formula will return a 1 for Monday, 2 for Tuesday, etc. There is also a function WeekdayName which gives the day name in clear text.

VBEval>Weekday("2014-07-21",2),res
VBEval>WeekdayName(%res%,,2),res2

MessageModal>%res%, %res2%
  View Snippet Page

[winstein]

Ah, I see. Thank you for your advice.