How to calculate business days for a given month & year.

[Saravanan13]

I would like get the total number of business days for respective month & year in a separate column. Can anyone assist on this

[IraWatt]

Hey @Saravanan13,

Do you just want the number of weekdays? Do you want to take into account public holidays?

[Saravanan13]

Yes weekdays along with public holidays.

[IraWatt]

@Saravanan13 bit of a roundabout way doing this in Alteryx but you can convert your text dates to a date data type then generate a row for each day of the month and filter off the Saturday and Sunday:

[Saravanan13]

Thank you so much. it worked