Date Difference Calculation

[Karthick30]

 Hi,

 I need to calculate Date Difference between 2 dates excluding Weekends. I am using NetWorkDays fuction.

If I have Start Date as 7/6/2022 and End Date as 7/7/2022 , my result for NetworkDays function is showing 2. I got  it as consider StartDate count as 1 and End Date count as 1. so result is 2. 

But Actual Difference between 7/6/2022 and 7/7/2022 is 1. I need the result as 1

Any way to achieve this Please

[sidhiq91 · Accepted solution]

@Karthick30  What you mentioned is right, networkdays returns 2 as a result. May be to return as 1, we might need to just subtract by 1.

NetWorkDays('07/06/2022','07/07/2022')-1

You can provide some real world data to look into it further.

[GnaneswarReddy · Accepted solution]

Use this NetWorkDays(Startdate,Enddate)-1

By subtracting 1 , we are ensuring that Start date wont be considered .