Previous week Networking Day

[Anonymous]

I am trying to create a variable which shows the number of working days in a previous week

This shows a working days in a current week.

Let Netwrkngdaysinaweek=NetWorkDays(Floor(WeekStart(Today())),Today());

shall i get something similar to this for the previous week?

[YoussefBelloum]

Hi,

try this:

Let Netwrkngdaysinaweek=NetWorkDays(Floor(WeekStart(Today(),-1)),Today());

[YoussefBelloum · Accepted solution]

or this for only the last week:

=NetWorkDays(WeekStart(Today(),-1),WeekEnd(Today(),-1))