Formula for business days?

laura.sandoval

Hi all! Quick question, we need a column that has a formula to find the difference between two columns of dates, but only counting business days. Is there a way to do this? Thanks!

bisaacs

Hey @laura.sandoval,

You'd use either NETWORKDAY or NETWORKDAYS.

Hope this helps!

laura.sandoval

@bisaacs oh it does thanks! Question, is there a way so it shows blank instead of INVALID DATA TYPE when those columns (for the formula) are empty?

bisaacs

Hey @laura.sandoval,

You can use IFERROR for that. It'd look something like this:

=IFERROR(NETWORKDAY(5/5/24, 5/10/24), "")

Hope this helps!