Grouping Dates

[rllysm0ll]

How do I write a code to create grouping for dates? (In terms of weekend vs weekday)

For Example:

17/7/2023 --> Weekday 

18/7/2023 --> Weekday

22/7/2023 --> Weekend

23/7/2023 --> Weekend

[BrunPierre · Accepted solution]

Try:

=If(Match(WeekDay(DateField), 'Sat', 'Sun'), 'Weekend', 'Weekday')