Data Preparation Date and by Date Range

[enocperez]

I have Data coming from Excel for Pay Roll.  

 

  How I need to take the data to the next step.  Week 1 Reg. Hour  and Over Time. Week 2  Reg. Hours worked and Over time.  But don't know how to do it.  I have been at it for some time know.

[enocperez]

So here is the version.

I have it working now.   About the formula to adjust the week number from Sunday to Monday.  I just add that to the expression or add another Formula with that expression.  Sorry again new to Alteryx.   

[JordanB · Accepted solution]

Hi @enocperez

Attached in the workflow which has the additional of the multi-row formula.

Best,

Jordan

[enocperez]

Thank you JordanB.  You help me out a lot.