calculate the number of working days between two dates without weekends and holidays

[Alison]

Hello,

Is there a solution for calculating the number of working days between two dates without weekends and holidays.

Please help

[vinebath]

Firstly, you should have two tables: 
1. Source table  with the records, and two fields of these records should be two dates that will set the period.
2. A table where you store holidays dates.

You should create a datapage on the first table and create a Calculated Field on the "Configure Results Page Fields" screen with the following code:

SELECT (DATEDIFF(dd, [@field:Date1], [@field:Date2]) + 1)
-(DATEDIFF(wk, [@field:Date1], [@field:Date2])*2)
-(
SELECT Count(*) FROM Holidays 
WHERE (Date BETWEEN [@field:Date1] AND [@field:Date2])
AND (DATENAME(weekday, Date) != 'Sunday' AND DATENAME(weekday, Date) != 'Saturday')
)

[@field:Date1] is a start date and [@field:Date2] is an end date, and Holidays is a table with the holidays days.

[cheonsa]

Hello!

Here's another post that calculates number of working days excluding weekends and holidays using Application Tasks: