SOLVED
Count consecutive days skip weekends
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BosKev
8 - Asteroid
‎06-15-2021
11:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
5 REPLIES 5
apathetichell
19 - Altair
‎06-15-2021
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
john_watkins
11 - Bolide
‎06-15-2021
12:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-15-2021
12:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
‎06-15-2021
12:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @john_watkins , this works great.
apathetichell
19 - Altair
‎06-16-2021
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
