Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Date.DayOfWeek
Returns the day of the week as a number from a date in Power Query.
Calculate Monthly Day Totals
Challenge No. 595: This challenge is contributed by 🇰🇷 Taeyong Shin
Create a table that calculates the number of weekdays, Saturdays, and Sundays using yearly and monthly data, and displays the total number of days in each month.
Solved using: Python in Excel.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Leave Group From To
Challenge No. 210: Populate the From and To Date based on type of leaves for a person.
Solved using: Python.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Custom Grouping! Part 18
Challenge No. 193: Separate sales into weekday sales (Mon-Fri) and weekend sales (Sat-Sun).
Solved using:Excel (DAY, FILTER, GROUPBY), Google Sheets, Power Query (Table.Group, Date.DayOfWeek, Table.AddColumn), Python, Python in Excel, and R.