Formula Library

Excel Formula To Calculate Business Days (Monday To Friday) In Imported Csv Text

Calculate business days using weekend code 1 in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Quick answer

Calculate business days (monday to friday) in imported csv text.

Unified formula

ExcelGoogle SheetsWPS
=NETWORKDAYS.INTL(A2, B2, 1)

How it works

Need a custom version?

Related formulas

Excel Formula To Calculate Business Days (Monday To Friday) In Transaction Text

Calculate business days using weekend code 1 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Calculate Business Days (Sunday To Thursday) In Transaction Text

Calculate business days using weekend code 11 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Calculate Business Days (Monday To Thursday) In Transaction Text

Calculate business days using weekend code 17 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Calculate Business Days (Tuesday To Saturday) In Transaction Text

Calculate business days using weekend code 12 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Calculate Business Days (Wednesday To Sunday) In Transaction Text

Calculate business days using weekend code 13 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Calculate Business Days (Custom Weekend Pattern) In Transaction Text

Calculate business days using weekend code 14 in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.