Define Your Custom Workdays

How to start the work week on another day than Monday, set up custom NetWorkDays and create a formula for daily targets.

Last updated: July 21, 2022

Table of contents

Does your work week start on Sunday and end on Thursday? Do you work on Mondays but not on Tuesdays? If so, you can adjust the time period on your widget or use a parameter in the formula that allows you to define custom workdays (NetWorkDays), days off, and weekends.

What to do if your work week starts on Saturday? Open the Advanced tab when selecting a time period on a widget and choose your custom work week. The widget will display data from Saturday to Friday instead of Monday to Sunday.

Custom Workdays - Week Starts on Saturday

If you use the Advanced formula editor, Plecto allows you to type in an optional parameter that defines which days of the week should be considered working days, and which – free. This parameter requires a combination of 7 digits, one digit per weekday where

  • 0 represents a workday AND
  • 1 represents a day free from work.

Take a look at the syntax below. The typing order in the formula goes from Monday to Sunday.

(
    NetWorkDays(StartDate(),EndDate(),0010011)
)

☝️ In this example, the formula will count the number of working days. If the time period on your widget is the Current week, the formula will display 4 (because you've told Plecto that your workdays are Monday, Tuesday, Thursday, and Friday – a total of 4 days).

(
    Holidays("DK",StartDate(),EndDate(),0001011)
)

☝️ In this example, the formula will count the number of holidays, but only if the holidays fall in on a Monday, Tuesday, Wednesday, or Friday.

Make sure to write the parameter correctly

The syntax will only be accepted in the formula editor if it contains all seven digits.

More examples with custom NetWorkDays
  • You work every day except Monday and Sunday.
    If time period is current week, formula result = 5.
(
    NetWorkDays(StartDate(),EndDate(),1000001)
)
  • You work only on Wednesdays.
    If time period is current week, formula result = 1.
(
    NetWorkDays(StartDate(),EndDate(),1101111)
)
  • Do you want to count all days of the week as workdays?
    If time period is current week, formula result = 7.
(
    NetWorkDays(StartDate(),EndDate(),0000000)
)
Tip – Combine custom NetWorkDays with custom time periods

If your work is based on custom NetWorkDays and the workweek starts on another day than Monday, make sure to adjust both your formula and the time period on the widget!

If you have a specific work schedule, you can use custom NetWorkDays to calculate and track your day-to-day progress more accurately. Build a formula similar to the one below – it takes the monthly target and divides it by the number of workdays (custom workdays that also exclude public holidays). 

(
    Last(Monthly target,Amount) /
    (
        NetWorkDays(StartDate(),EndDate(),0000110) 
        -
        Holidays("US")
    )
)
Copy the formula, but use your own information

Make sure to add your own data source, NetWorkDay parameter and holiday country code.

Was this article helpful?

Please leave a comment to help us improve.

Related articles

Advanced Formula Editor

Date & History Modifiers

IF Statements

AND & OR Statements

History Modifier With Examples

See more