Challenge No. 143: Groups the sales values every week starting from Friday days starting from 1/1/2024.
Solved using:Excel (GROUPBY, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.WeekOfYear, Table.AddColumn), Python, Python in Excel, and R.
WEEKNUM
Returns the week number of a date in Excel.
Sales Calendar Extraction!
Challenge No. 18: Dynamically generate a sales calendar for the month entered in F3, based on data from the given table.
Solved using:Excel, Power Query, and R.
