Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAProbably could have done it a bit cleaner - But got there!
-Added Record Number
-Transpose to get Dates all in one Column for Date conversion
-Convert to Date Format
- Split workflow
-upper Workflow get Month Year by record number
-lower workflow Isolate P1 & P2 Records
-Generate Rows to get dates between Start and End Periods
-Convert generated dates to "Weekday" Values & Flag Weekend Days
-Filter Out Weekend days
-Group and Count Weekdays for P1 & P2 values
-Join P1 & P2 Values by record number back to original Set.
-Join back to original