Format a Date as Ddd dd-Mmm-yyyy in Excel for Android
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.
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.
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.
Open the workbook in Excel for Android and tap an empty cell, such as B1, next to the date in A1.
Tap the formula bar and enter =TEXT(A1,"ddd dd-mmm-yyyy"), replacing A1 with the cell that contains your date.
Confirm the formula. The cell displays a result such as Wed 05-Jan-2022; copy the formula down to format additional dates.
Apply a Custom Date Format in Desktop Excel
Use desktop Excel if you want to format the original date cell instead of creating a separate display cell.
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. Open the workbook: Open WPS Office on Android and select your spreadsheet from Files.
- 2. Select a display cell: Tap an empty cell next to the date, such as B1 when the date is in A1.
- 3. Enter the formula: Tap the formula bar and enter =TEXT(A1,"ddd dd-mmm-yyyy"), adjusting the cell reference if needed.
- 4. Confirm and save: Confirm the formula, check the displayed date, and tap Save to keep the change.

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.




