Help with the "Day of Week" function and its loop!

Goodmorning everyone,

I’m working on a project without the orchestrator and I should work on an excel file that I find in a folder.
This file must be processed today -1 except on Saturdays and Sundays.
It occurred to me to use the DayOfWeek function, so when the robot finds “Monday” instead of doing today -1, I do today -2.
But it happens that I don’t know how to do the “if” for each day.

Some idea?

Thanks in advance!


Hi @Araceli91

You can try this

	{"Saturday", "Sunday"}.Contains(Now.DayOfWeek.ToString),
	"Do Not Process",

If today is Monday it will give Friday
For Tue to Friday it will give Mon to Thu

Use it in assign Activity


your flow seems correct

You can put the IF condition and mention expression

Now.dayoftheweek.tostring = “Sunday” or Now.dayoftheweek.tostring = “Saturday”

I will try the two solutions and tell you how it was!

Thanks so much!

I am trying your solution right now, do you know if it is possible to convert the day it comes back to me (For example "Friday) to date (11/05/2021)



checked on a test series:

find starter help here:
GetPreviousWorkday.xaml (5.4 KB)

1 Like

OMG!! omg thank so so much!!!

I finally solved it! I share the function, I hope it will be useful to you.

ControlloGiorniLavorativi.xaml (7.5 KB)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.