SOLVED

Is there an easier way to

%3CLINGO-SUB%20id%3D%22lingo-sub-1795638%22%20slang%3D%22en-US%22%3EIs%20there%20an%20easier%20way%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795638%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20an%20easier%20way%20to%20do%20this%3A-%20'%3DIF(WEEKDAY(A103)%3D6%2CFriday%2CIF(WEEKDAY(A103)%3D7%2CSaturday%2CIF(WEEKDAY(A103)%3D1%2Csunday%2CIF(WEEKDAY(A103)%3D2%2Cmonday%2CIF(WEEKDAY(A103)%3D3%2CTuesday%2CIF(WEEKDAY(A103)%3D4%2CWednesday%2CIF(WEEKDAY(A103)%3D5%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1795638%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-1795700%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20easier%20way%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F263905%22%20target%3D%22_blank%22%3E%40Csausy%3C%2FA%3E%26nbsp%3Byes%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DTEXT(A103%2C%22dddd%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eor%20if%20you%20want%20A103%20or%20the%20new%20cell%20to%20only%20display%20that%20way%20(i.e.%20the%20cell%20still%20has%20the%20date%20value%20but%20only%20displays%20the%20day%20of%20the%20week)%20then%20under%20custom%20format%20use%20%22dddd%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796817%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20easier%20way%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20that%20is%20brilliant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1807913%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20easier%20way%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1807913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F263905%22%20target%3D%22_blank%22%3E%40Csausy%3C%2FA%3E%26nbsp%3BHave%20you%20any%20other%20useful%20tips%20like%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Is there an easier way to do this:- '=IF(WEEKDAY(A103)=6,Friday,IF(WEEKDAY(A103)=7,Saturday,IF(WEEKDAY(A103)=1,sunday,IF(WEEKDAY(A103)=2,monday,IF(WEEKDAY(A103)=3,Tuesday,IF(WEEKDAY(A103)=4,Wednesday,IF(WEEKDAY(A103)=5

5 Replies
Highlighted
Best Response confirmed by Csausy (Occasional Contributor)
Solution

@Csausy yes

=TEXT(A103,"dddd")

or if you want A103 or the new cell to only display that way (i.e. the cell still has the date value but only displays the day of the week) then under custom format use "dddd"

Highlighted

@mtarler 

Thank you that is brilliant.

 

 

Highlighted

@Csausy Have you any other useful tips like that ?

 

Highlighted

@Csausy  "useful" is a relative term dependent on what you already know, and what you might need to know, and I know neither of those answers.  That said I would highly recommend reading these posts here and follow what these experts post as you can learn a ton from them.  You may not know/understand everything they are doing but learn from the ones you can and you can always ask questions.  Best of luck.

Highlighted

@mtarler  Thanks for that.

I only  dabble and keep records. But I like learn new, and to know that I am doing it properly,

 

Thanks for your time.