Representing a Date Range List as a List of Days

[MauriceWhelan]

Hi.

I have a column called [Date Range List] which has an AppFormula that returns a list of Dates based on the [From] and [To] Date values. What I want to achieve is to add an additional field called [Day Range List] and this would be a Day of the Week representation of what is in the [Date Range List] field. e.g.
30/11/2020,01/12/2020,02/12/2020 would be Monday, Tuesday,Wednesday.

Any help would be great, thank you.

[Suvrutt_Gurjar · Accepted solution]

Please explore following approach-

Since you are already having a date range formula, I presume you have a date column. Depending on your app design, you may add another real or virtual column with an expression such as say TEXT([Date], “DDDD”) and may call it say [Weeklyday]

You could then base your [Day Range List] expression exactly like [Date Range List] expression except replacing [Date] in the expression with[Weeklyday]

[MauriceWhelan]

Thank you @Suvrutt_Gurjar. That seems to have done the trick.