Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.
MONTH
Returns the month number from a date in Excel.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Last Sundays Of Year
Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.
Insert Quarterly Totals
Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.
Calculate Red Highlighted Area
Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: 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.
Five-Weekend Month Finder
Challenge No. 541: List the months and years having 5 Fridays, 5 Saturdays and 5 Sundays in a month for the years 2000 to 2999.
Solved using: Python in Excel.
Monthly Running Max Total
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.
Group Per Month
Challenge No. 60: Group the customers per month.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.