Skip to main content
Solved

Date Duration Exclude Weekend

  • Oct 21, 2019 8:24 AM UTC
  • 0 replies
  • 120 views
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

[End Date] - [Start Date]

It appears if there is for example employee taking leave from Friday to Monday. It will count also weekend as duration

How to exclude weekend from duration calculation?

Many thanks




------------------------------
Syaeful Bahri
------------------------------

Best answer by AustinK

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]))
View original
This topic has been closed for replies.

  • AustinK
  • Qrew Colonel
  • Answer
  • Oct 21, 2019 2:51 PM UTC
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]))
Terms & ConditionsAccessibility statement