Challenge No. 695: Develop Broadcast Calendar for 2025.
Solved using: Python.
Date & Time Handling
Working with date and time values.
Detect Overlapping Tasks
Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.
Calculate Actual Task Durations
Challenge No. 631: This challenge has been contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python in Excel.
Find Immediate Previous Caller
Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.
Identify 2025 Palindromic Dates
Challenge No. 621: Dear Patrons,
=LET(n,”72658080893278698732896965823250485053″,CONCAT(CHAR(MID(n,SEQUENCE(LEN(n)/2,,,2),2))))
Find out which dates are Palindromic dates in year 2025.
Solved using: Python.
Schedule Tasks Using Dependencies
Challenge No. 618: Today’s challenge is contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python.
Detect Possible Date Formats
Challenge No. 605: Out of 3 date formats only, MDY, DMY & YMD, list the date formats for given dates.
Solved using: Python.
Find Time Extremes by Date
Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.
Calculate Name-Based Durations
Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.