Count consecutive days skip weekends

[BosKev]

Hi,

How do I count the number of consecutive days without weekends? Thanks.

Employee Full Name	Work Date	Desired Out put Consecutive Days
A	5/3/2021	1
A	5/4/2021	2
A	5/5/2021	3
A	5/6/2021	4
A	5/7/2021	5
A	5/10/2021	6
A	5/11/2021	7
A	5/12/2021	8
A	5/13/2021	9

[apathetichell]

This is the easiest way...

[dataguyW · Accepted solution]

There are many ways to go about this.  This way is very basic and works.  

[BosKev]

@apathetichell Thanks, I forgot to mention there are multiple employees, the recordID tool is good solution but doesn't work if there are more than one employee.

[BosKev]

Thanks @dataguyW , this works great.

[apathetichell]

Yeah for multiple employees you can turn it into a (regular) macro and feed in the employee and  min/max date for each employee (which you get via summarize tool).

If you come back to that version - and need help implementing it that way, let me know.