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: 2562
So, could someone help by telling me what is causing this and what I need to do to correct it?
2 Replies
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!
