How to get the weekday name from a date
✓ Verified in LibreOffice 25.8.7.3Turn a date into its day-of-week name, like "Monday".
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =TEXT(A2,"dddd") | "ddd" gives the short form (Mon). |
| Google Sheets | =TEXT(A2,"dddd") | Identical. |
| LibreOffice Calc | =TEXT(A2,"DDDD") | Case-insensitive; "dddd" also works. |
How it works
TEXT with the "dddd" format code renders a date as its full weekday name; "ddd" gives the three-letter abbreviation. July 20, 2026 falls on a Monday. If you need the weekday as a number instead (for sorting or logic), use WEEKDAY(A2) in all three apps.
Verified, not just documented
We ran =TEXT(DATE(2026,7,20),"DDDD") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned Monday — exactly the expected result. Every formula here is confirmed by actually executing it.