Formatting Issues

Format a Date as Ddd dd-Mmm-yyyy in Excel for Android

Khadija KhanKhadija Khan Nov 14, 2026 868 views

Question details

The user wants to display an Excel date with an abbreviated weekday, day, abbreviated month, and year on Android.

Product
Microsoft Excel for Android
Device & OS
Android
Scenario
Display a date in a format such as Wed 05-Jan-2022 when custom date-format options are limited on mobile.
Observed behavior
Excel for Android does not offer the same custom date-format options as desktop Excel.
Before you start

Make sure the source cell contains a valid Excel date rather than text. Identify an empty cell for the formatted result if you plan to use a formula.

Solution 1Recommended

Use the TEXT Function in Excel for Android

Use a separate cell to display the date in the requested format without changing the original date.

1
Select an empty cell

Open the workbook in Excel for Android and tap an empty cell, such as B1, next to the date in A1.

2
Enter the formula

Tap the formula bar and enter =TEXT(A1,"ddd dd-mmm-yyyy"), replacing A1 with the cell that contains your date.

3
Confirm the result

Confirm the formula. The cell displays a result such as Wed 05-Jan-2022; copy the formula down to format additional dates.

The result is text: The formula produces text in a separate cell. Keep the original date cell for date calculations and sorting by date. Weekday and month abbreviations can depend on locale settings.
Format dates in WPS Office

Display Dates with Weekdays in WPS Spreadsheets

In WPS Spreadsheets, use the TEXT function in a separate cell to display a date with an abbreviated weekday while keeping the original date available for calculations.

  1. 1. Open the workbook: Open WPS Office on Android and select your spreadsheet from Files.
  2. 2. Select a display cell: Tap an empty cell next to the date, such as B1 when the date is in A1.
  3. 3. Enter the formula: Tap the formula bar and enter =TEXT(A1,"ddd dd-mmm-yyyy"), adjusting the cell reference if needed.
  4. 4. Confirm and save: Confirm the formula, check the displayed date, and tap Save to keep the change.
Display dates with abbreviated weekdays and monthsKeep the original date value for calculationsOpen and save Microsoft Excel XLSX workbooksUse a familiar spreadsheet interface on Android
QA img-9

Frequently Asked Questions

How do I show the weekday and date in one Excel cell on Android?

Tap an empty cell and enter =TEXT(A1,"ddd dd-mmm-yyyy") in the formula bar, where A1 contains the original date.

Does the TEXT formula change the original date?

No. It displays a text result in the formula cell and leaves the date in the source cell unchanged.

Why does my formula not show an English weekday abbreviation?

The weekday and month abbreviations can depend on locale settings. Check the workbook or device locale if you need English abbreviations.

Can I apply the format without using a second cell?

In desktop Excel, select the date cells and open Format Cells > Number > Custom. Enter ddd dd-mmm-yyyy as the Type, then save the workbook.