Forum Discussion

SyaefulBahri3's avatar
Qrew Trainee
5 years ago

Date Duration Exclude Weekend

Hi All, I have a field like this Employee Name | Leave Type | Start Date | End Date | Duration I set Duration field as Formula Duration with this formula to count employee leave duration [...
  • AustinK's avatar
    5 years ago
    WeekDaySub([start date],[end date])

    You might need to change it to a formula date field and then change your start date and end date to dates in the formula as well. So if that doesn;t work then try this with my previous advice.

    WeekDaySub(ToDate([start date]),ToDate([end date]))