Challenge No. 184: List the years in this century which are having at least 2 months which had 5 Fridays, 5 Saturdays and 5 Sundays.
Solved using: Python in Excel.
DATE
Returns a date from year, month, and day values in Excel.
Find Pythagorean Dates
Challenge No. 156: Pythagorean dates are those dates where DD^2 + MM^2 = YY^2
For example: 16-Dec-2020 where 16^2 + 12 ^2 = 20^2
List all Pythagorean dates (in YYYYMMDD format) from current century.
Solved using: Python in Excel.
Extract Complete Months
Challenge No. 32: Calculate the number of complete Months per Year per Project
For example, Proj A starts in 2022 (for 10 months), 2023(12 months), Ends 2024(6 months)
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Weekday Count of Christmas
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
List 1st, 3rd, 5th Saturdays
Challenge No. 80: List the 1st, 3rd and 5th Saturdays of all months for a given year in A1.
Solved using: Power Query.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
List 2nd and 4th Saturdays
Challenge No. 56: Provide a formula to generate the list of 2nd and 4th Saturdays for a given quarter and year in A1.
Solved using: Power Query.
Find Last Mondays after 25th
Challenge No. 52: Provide a formula to list the Last Mondays of each month for a given year in A1 if Last Monday falls on a day > 25.
Solved using: DAX.
Missing Values! Part 2
Challenge No. 62: The question table presents the actual progress of 3 projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, IF), Power Query (Date.Month), Python, and R.