If I want to find date before 3 day (not count holiday) *I read date holiday by file excel as below. holidays.xlsx (13.1 KB) WorkingORnot.xaml (12.9 KB) Example : today 20/05/2021 but in file holiday 20/05/2021 as holiday. I want to find by count the days back 3 day. Output : 17/05/2021 Plea…

Find date?

sarathi125 (Parthasarathi) May 21, 2021, 6:22am 2

Try with this workflow, I have downloaded your xlsx and updated for today’s date in it to test the workflow.

Find date before 3 days and not in holiday

Topic		Replies	Views
Find date before 3 days and not in holiday Activities excel , activities , question	1	816	May 21, 2021
Compare Now Date from Excel Date Help	16	2087	October 29, 2018
How to find month before today 3 days (working day)? Activities uiautomation , activities , web , question	9	2189	May 3, 2021
Check if today is holiday from Excel Studio	5	1247	July 15, 2021
Find month before today 3 day (working day) and convert month that use local month name Activities activities , web , question	1	655	April 30, 2021