Hi I have a column called [Weekday] (Type = ‘Text’) which contains an App Formula that returns a list of WEEKDAY() values based on a date range ([From Date] & [To Date]) entered by the user
e.g. [From Date] = 19/10/2020, [To Date]=23/10/2020, [Weekday]=2,3,4,5,6
Using this example what expression would I use to identify that 6 is the highest number in the result for [Weekday]?
Many thanks.
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |