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

%3CLINGO-SUB%20id%3D%22lingo-sub-3022333%22%20slang%3D%22en-US%22%3EWhy%20is%20date%20returning%20numbers%20when%20I%20want%20it%20to%20show%20day%20of%20week%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3022333%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Excel%20in%20Office%20365%20and%20using%20the%20following%20formula%20to%20generate%20the%20day%20of%20the%20week%20from%20a%20date%2C%20where%20A2%20represents%20the%20date%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3Dtext(A2%2C%20%22BBB%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExpected%20result%3A%20Friday%3CBR%20%2F%3EActual%20result%3A%202562%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20could%20someone%20help%20by%20telling%20me%20what%20is%20causing%20this%20and%20what%20I%20need%20to%20do%20to%20correct%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3022333%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3022391%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20is%20date%20returning%20numbers%20when%20I%20want%20it%20to%20show%20day%20of%20week%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3022391%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1234826%22%20target%3D%22_blank%22%3E%40Jamie_Mitchell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DTEXT(A2%2C%22dddd%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Edddd%20stands%20for%20the%20full%2C%20unabbreviated%20name%20of%20the%20day.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DTEXT(A2%2C%22bbbb%22)%20returns%20the%20Buddhist%20year%2C%20as%20used%20in%20Thailand.%20It's%20the%20Gregorian%20year%2B543.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

@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.

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