Need a hand with finding most common date in month

AppSheet AppSheet Q&A
1

Hey all,

I have two columns of use here:

[Scheduled start date] which is a selected date. Can be any.
[Day of the week] an enumlist for each day of the week.

If you select 1/1/2025 for [scheduled start date] and “Monday, Friday” for [day of the week] I want to see which day of the week has the most occurences in 1/2025. Just return the date with the highest e.g. “Friday” which would return as 6.

This is tripping me up more than it should haha. Any help is much appreciated.

2

I believe this could be done. However could you mention more examples of this requirement so that the community could suggest better.

Also please mention what does it mean by [schedule start date] “selected” ? How is it selected ?

1 Like