Weekdays and Weekends in Date Calculations (WD/WE)

1. Overview

Formula fields in Clevero can calculate the difference between two dates using the DATEDIF function. Besides years, months and days, DATEDIF has two units for working-day calculations:

• "WD" counts weekdays (Monday to Friday) between two dates.

• "WE" counts weekend days (Saturday and Sunday) between two dates.

Use these units on any record with two date fields when calendar days alone would be misleading.

2. Common Uses

The WD unit can be used to calculate:

• Working days in a project, task or contract period

• Business days between a request date and a completion date

• Weekdays within a leave, booking or absence period

The WE unit can be used to calculate:

Watch the guided demo below to create a new field.

You can also follow the same steps using the written guide below.

Before you start, make sure the record has two date fields, for example a start date and an end date.

1. Go to Settings > System Settings > Records.

2. Select the required record.

3. Select Fields, then click Add Field.

4. Enter a Field Name (for example, Weekdays or Weekend Days).

5. In Data Type, select Formula.

6. Under Write Formula, click + Formula, search for DATEDIF under Date & Time, and select it.

7. With the cursor inside the brackets, click + Variable and select the start date field.

8. Type a comma, click + Variable again and select the end date field.

9. Type a comma followed by the unit: "WD" for weekdays or "WE" for weekend days.

10. Click Save.

Your formulas will look similar to these, with your own field IDs in place of the placeholders.

Weekdays (WD):

DATEDIF({{[start-date-field-id]}}, {{[end-date-field-id]}}, "WD")

Weekend days (WE):

DATEDIF({{[start-date-field-id]}}, {{[end-date-field-id]}}, "WE")

📘 Note: Create a separate formula field for each unit, for example one field with "WD" and another with "WE". Always insert date fields with + Variable rather than typing them, so the correct internal field IDs are used.

4. Configuration

DATEDIF uses the following syntax:

DATEDIF(start_date, end_date, unit)

Weekdays and weekend days always add up to the total number of days: 44 + 18 = 62.

6. Notes