Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.
EOMONTH
Returns the last day of the month, a specified number of months from a given date 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.
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 Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Final Week Of The Month!
Challenge No. 134: From the “transactions” in the provided table, filter those that occurred in the last 7 days of the month.
Solved using:Excel (CHOOSECOLS, DAY, EOMONTH), Google Sheets, Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and SQL.
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.
Populate Start & End Date from a month name
Challenge No. 35: Populate Project Start & End Dates Given Start Month & Duration Assume Start (1st of Month) & End (Last day of Month)
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Missing Values! Part 1
Challenge No. 54: The table presents the actual progress of three projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, EOMONTH), Power Query (List.Transform, Table.Group, Table.TransformColumnTypes), Python, and R.
Duration Since Last Visit!
Challenge No. 38: In the question table, the visiting dates for all 4 agents are provided.
Solved using:Excel (AVERAGE, DROP, EOMONTH), Power Query (List.Transform, Table.AddColumn, Table.Group), Python, and R.
Calculate Average Inventory Level!
Challenge No. 8: The Question’s table outlines warehouse transactions with records for Initial value (warehouse product count), Add (purchased and incoming products), and Reduce (sold and outgoing products).
Solved using:Excel, and Power Query.