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 Format Date As Dddd, Mmm Dd In Analytics Event Text

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

Format dates as dddd, mmm dd in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format date as dddd, mmm dd in analytics event text.

ExcelGoogle SheetsWPS

=TEXT(A2, "dddd, mmm dd")

Format dates as yyyy-mm-dd in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format dates as dd/mm/yyyy in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format dates as mm/dd/yyyy in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format dates as dd-mmm-yyyy in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format dates as mmm dd, yyyy in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Format dates as yyyy-mm in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.