Forum Discussion
Why is date returning numbers when I want it to show day of week?
I'm using Excel in Office 365 and using the following formula to generate the day of the week from a date, where A2 represents the date: =text(A2, "BBB") Expected result: Friday Actual result...
Use
=TEXT(A2,"dddd")
dddd stands for the full, unabbreviated name of the day.
=TEXT(A2,"bbbb") returns the Buddhist year, as used in Thailand. It's the Gregorian year+543.
- Thanks Hans - I feel slightly stupid, but very grateful!
