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 (Wednesday To Sunday) In Analytics Event Text

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

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

Calculate business days (wednesday to sunday) in analytics event text.

ExcelGoogle SheetsWPS

=NETWORKDAYS.INTL(A2, B2, 13)

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 11 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.