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 infor…

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

monday Community Forum

Weekday Formula?

Platform discussions

JCorrell (Jim - The Monday Man) October 1, 2022, 6:46pm 5

@mark.anley

not better… just different.

Topic		Replies	Views
Identifying Saturdays/Sundays in date calculations Feature requests workload	6	5660	September 11, 2022
Weekday formula not corresponding with timeline Platform discussions timeline , formula	1	8	August 27, 2024
Get Sunday occurences from a timeline column Platform discussions columns , timeline	3	2359	May 4, 2022
Autoboost formula: Determining day of week monday apps & integrations automations , formula , date	0	993	July 16, 2023
Number of Weeks between 2 dates in the same column Platform discussions formula	2	1375	July 31, 2023