Challenge No. 207: DATE CIPHER
Date cipher is a type of Caesar’s shift cipher where key is current date in YYYYMMDD format.
Solved using: Excel VBA.
Date & Time Handling
Working with date and time values.
Sum-Month Equals Year Dates
Challenge No. 199: List the count of dates along with Min and Max date for the rows in columns A & B where MM + DD = YY.
Solved using: Python in Excel.
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.
Year Plus Digits Equals Current
Challenge No. 192: Excel formulas permit date range from 1-Jan-1900 to 31-Dec-9999.
Solved using: Python in Excel.
List Buy and Sell Balances
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
Convert Dates to US Format
Challenge No. 181: Convert DMY text dates to MM/DD/YYYY format.
Solved using: Power Query.
Distribute Amount Monthly
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).
Fill Missing Store Dates
Challenge No. 50: If there is a discontinuity in dates for a Store, fill in the missing dates with details of previous records and also fill in the sequence of record numbers for a customer in that store.
Solved using: SQL.
Determine Cumulative Sum Based on Rules
Challenge No. 49: Generate the output table shown.
Solved using: SQL.
List Sales Figures Across Dates
Challenge No. 48: — Input table Quantity data is wrong in picture.
Solved using: SQL.