SOLVED

# Is there an easier way to

Occasional Contributor

# Is there an easier way to

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
best response confirmed by Csausy (Occasional Contributor)
Solution

# Re: Is there an easier way to

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

# Re: Is there an easier way to

Thank you that is brilliant.

# Re: Is there an easier way to

@Csausy Have you any other useful tips like that ?

# Re: Is there an easier way to

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

# Re: Is there an easier way to

@mtarler  Thanks for that.

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