Skip to Content
0
Jan 17, 2023 at 10:06 AM

How to calculate days between excluding weeke

165 Views

Calculation Colum - how to calculate working days excluding weekend(Sat & Sun).

I have tried this fomrula:

if(isnull("Resolution_Date") OR "Resolution_Date" = ' ' OR isnull("Created_date") OR "Created_date" = ' ',' ',

string(daysbetween(date("Created_date"),date("Resolution_Date")))

However, this formula only calculates working days. Please guide me through.

)