Challenge No. 174: For all employees, insert the rows for each month and divide the Sales amount over these months as per number of calendars days in the month.
Solved using: R.
MONTH
Returns the month number from a date in Excel.
Min and Max Dates by Group
Challenge No. 398: Generate the min and max dates for different year and month combinations.
Solved using: Python in Excel.
Last Weekday of Each Month
Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.
Monthly Flight Time Summary
Challenge No. 154: This problem is a variation of yesterday’s problem.
Solved using: Power Query.
Monthly Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
Custom Grouping! Part 15
Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), Python, Python in Excel, and R.
Find Monthly Min Max Dates
Challenge No. 99: Find when the Min and Max occurred for various months and corresponding dates.
Solved using: Power Query (Text.Combine).
Custom Grouping! Part 12
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Sales Based on Custom Month Range
Challenge No. 92: The accounting month of this company finishes on last Friday of the month.
Solved using: Python in Excel.