Add additional date column with only business days

Hi All,

I have a dataset in which I have the month & year column. I want to add 2 additional columns for date - one with business days for that month & other column with regular dates. Giving an example screenshot below. If the number of records for a particular month is more than number of business days / regular days, I would want the days to repeat (in a round robin like fashion, starting again from the first business day / regular day).

Would really appreciate some help on this. Thanks.

Add business days.PNG

Workflow

Input

Output

Date Time

Accepted answers

pcatterson

Ah, a different question. You want to evenly assign the data a number from 1 through 21 for Business Days and 1 through 31 for All Days. Is that right?

Even Assignment.yxmd

All comments

pcatterson

Do you mean like this?

Business Days List.yxmd

sagar_agarwal

Hi - Yes exactly like this. Except that I don't want the dates to keep on adding.

I have approx 100,000 rows for each month. So for "All Days" column, I want the number to repeat something like "1,2,3,4,....31,1,2,3,4,.....31...and so on"

Similarly for business days, it should be something like "1,2,3,4,5,8,....22,1,2,3,4,5,8,...22...." and so on.

The idea is that my data did not had any day field, so I am trying to evenly distribute the rows for a month across the date range of "All Days" & "Business Days". I hope I could explain my requirement.

pcatterson

Ah, a different question. You want to evenly assign the data a number from 1 through 21 for Business Days and 1 through 31 for All Days. Is that right?

Even Assignment.yxmd

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157