Dec 01 2021 04:31 AM
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?
Dec 01 2021 04:49 AM
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.
Dec 01 2021 05:04 AM