How to find number of days between dates excluding weekends using saved search formula please ??

Example formula: Using a Formula (numeric) field something like this should work, ROUND(((TO_CHAR({systemnotes.date}, 'J') - TO_CHAR({trandate}, 'J'))) + MOD(({systemnotes.date} - {trandate}), 1) - ((((TRUNC({systemnotes.date}, 'D')) - (TRUNC({trandate}, 'D')))/7)*2) - (CASE WHEN TO_CHAR({trandate}, 'DY') = 'SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({systemnotes.date}, 'DY') = 'SAT' THEN 1 ELSE 0 END), 2)

Thanks will try it.

You'll need to factor in your own date fields though based off of what you're searching for. This example is calculating between system notes date and the transaction date.

Yeah it worked I am using on the trandate field(invoice) and startdate field(project). Thanks @Chloë