Weekday Formula?

Hello all, new member here.

I want to find out the average number of events that my company has on each day of the week for the year and use that data as a guide for shift scheduling. How do I create a “weekday” column listing the day of the week? My plan is to use that column and display the information in a graph.

This would be a trivial task in excel, but there is no weekday formula from what I can tell based on the list of available formulas article on the support page.

Thank you

Hi @KevL - you can use a Formula column and use the following formula:

SWITCH(WEEKDAY({Date}),
1,“Monday”,
2,“Tuesday”,
3,“Wednesday”,
4,“Thursday”,
5,“Friday”,
6,“Saturday”,
7,“Sunday”)

Thanks,
Mark

1 Like

@KevL @mark.anley

Here’s another way also:
FORMAT_DATE({Date}, "dddd")

I have documented many of the available, previously undocumentd functions that can be used in monday formulas (including the one Mark used) here.

1 Like

@JCorrell - Thanks, yours is far better :slight_smile:

@mark.anley

not better… just different.

@JCorrell @mark.anley

Thank you both for your help. I will definitely boookmark that link.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.