Challenge No. 695: Develop Broadcast Calendar for 2025.
Solved using: Python.
DATE
Returns a date from year, month, and day values in Excel.
Quarterly Payment Grouping
Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.
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.
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.
Find Perfect Square Dates
Challenge No. 292: List all dates in 21st century which are perfect square dates.
Solved using: Python.
Calculate Quarterly Working Payment
Challenge No. 100: Per day rates for every person for a duration is given.
Solved using: Python in Excel.
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
List Dates Matching Product Rule
Challenge No. 262: List the dates in YYYY-MM-DD format from 21st century i.
Solved using: Python in Excel.
Custom Grouping! Part 7
Challenge No. 133: Group the monthly sales values into three categories based on the following logic and provide one of the result tables:
Group 1: 1st to 10th of the month
Group 2: 11th to 20th of the month
Group 3: 21st to the end of the month.
Solved using:Excel (DATE, DAY, DROP), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddColumn), Python, Python in Excel, and R.