Compare Value for date which is working day in UI path studio X

Hello Everyone,

Can you please help me on my below query

I have excel in which there are date according to our calendar
so, for every date there is some numeric value available, but not for saturday and sunday and Holiday

so, i want to check that numeric if value is 0 for working days.

I am working in UI path studio X

Thank you

You can do that using Excel. Define a new column in Excel where you output true/ false based on a cell formula (e.g. using WEEKDAY Excel function). AutoFill activity can help to apply the formula to all your data. Then, in StudioX, you can use IF activity inside a For Each Row to make your validation