Why is date returning numbers when I want it to show day of week?

[Jamie_Mitchell]

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]

@Jamie_Mitchell 

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.

[#3]

Thanks Hans - I feel slightly stupid, but very grateful!