Weekday Formula?

[KevL (Kevin Leinhos)]

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

[mark.anley (Green Llamas Consulting)]

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

monday.com + Green Llamas

[JCorrell (Jim - The Monday Man)]

@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.

[mark.anley (Green Llamas Consulting)]

@JCorrell - Thanks, yours is far better

[JCorrell (Jim - The Monday Man)]

@mark.anley

not better… just different.

[KevL (Kevin Leinhos)]

@JCorrell @mark.anley

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