Calculation between Dates - Networkdays

[jerryr125]

Hi - 

Question: 

On my dataload I am creating a field to calculate number of days between two days.

Field:  PRDate

Format: mm/dd/yyyy

Example: 7/08/2021

Field: WDate

Format: mm/dd/yyyy

Example: 6/29/2021

Formula:

Floor(PRDate)-floor(WDate) 

Value: 9

Formula:

NetWorkDays(PRDate,WDate)

Value:  0

Why does the Formula for NetWorkDays display 0 ? 

I would think the value should be 7 

Any thoughts ? 

[Kushal_Chawda · Accepted solution]

@jerryr125  Networkday function takes the first parameter as start date and second parameter as End date. In your case you need to reverse the Dates like below

NetWorkDays(WDate,PRDate)

[jerryr125]

Excellent -thank you !  Works perfectly!