Networkdays

Hi Appsheet,

Just wanna ask if you have already come up with a built-in formula of NETWORKDAYS()? My problem basically is that, I need to count the no. of days excluding weekends and holidays from a given starting date up to now() then return that number.

Thanks in advance!

Regards,

Add a count column for worked day and just do last - the one you want from

Not very elegant but it should work…
2*HOUR([DATE]-TODAY())/24-
HOUR(WORKDAY(TODAY(),HOUR([DATE]-TODAY())/24)-TODAY())/24

4 Likes

Thank you Aleksi!

You’re welcome