Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

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

Paste the formula into the first output cell, then fill down to apply it to your range.

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

Calculate business days (sunday to thursday) in transaction text.

ExcelGoogle SheetsWPS

=NETWORKDAYS.INTL(A2, B2, 11)

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

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

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

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

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

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