Identifying the Max value in a list of numbers

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.

0 6 678
6 REPLIES 6
Top Labels in this Space