How to get how many weekdays and weekends left in the month?

[bryanmac_92]

I am trying to figure out how to find how many weekdays and weekends left of the month on each row.

This workflow would be running weekly so more rows will be added so not sure how to accomplish this.

Date

3/6/2023

3/2/2023

2/20/2023

3/1/2023

3/3/2023

3/4/2023

3/1/2023

2/26/2023

[binuacs]

@bryanmac_92 Are you looking for something like this

[Christina_H]

You can do this with a series of formulas

Note: this includes the initial date.

(Working days calculation from Solved: Count workday difference between 2 dates - Alteryx Community)