Return Day Name I need an expression to ret...

(Aaron Moolb) #1

Return Day Name

I need an expression to return the name of the day from a column that shows the Day Number.

Example: If =DAY(TODAY()) returns 27, My expression in the “Day Name” column needs to return “Tuesday”

Any suggestions?

(Levent KULAÇOĞLU) #2

@Aaron_Moolb IFS( WEEKDAY(TODAY())=“1”,“Sunday”, WEEKDAY(TODAY())=“2”,“Monday”, WEEKDAY(TODAY())=“3”,“Tuesday”, WEEKDAY(TODAY())=“4”,“Wednesday”, WEEKDAY(TODAY())=“5”,“Thursday”, WEEKDAY(TODAY())=“6”,“Friday”, WEEKDAY(TODAY())=“7”,“Saturday” )

(Aaron Moolb) #3


What about different months? So, the 1st of the month is not always a Sunday.

Example, the first of this month was a Thursday

(Fernando López) #4

What @Levent_KULACOGLU said works…

(Levent KULAÇOĞLU) #5


WEEKDAY expression accept a date as a parameter. So: WEEKDAY(“1/11/2018”) will return 5

(Aaron Moolb) #6

@Levent_KULACOGLU I know how to get the number. I need to return the day name of month.

Example: WEEKDAY(TODAY()) returns 27. I want to return “Tuesday”

(Levent KULAÇOĞLU) #7


WEEKDAY(TODAY()) cannot return 27. The response range is from 1 to 7, 1 being Sunday…You can use the IFS expression that I have proposed to return the name of the weekday as per date. - WEEKDAY() WEEKDAY()

(Aaron Moolb) #8


I understand, it was a bad example because today is the 27th. What I need is the exact name of the DJ. The problem with your statement is that one always return Sunday. That is not always the case. The first day in November was Thursday. How do I get an expression to show That the first day of November 2018 is Thursday and not Sunday?

(Aaron Moolb) #9

I’m trying to avoid adding a table with endless amounts of calendar dates and day names and just doing a lookup

(Levent KULAÇOĞLU) #10

@Aaron_Moolb do apologize if I’ve been misunderstood. But the solution is already in front of you: WEEKDAY(“1/11/2018”) returns 5 (Thursday) not 1. WEEKDAY(TODAY()) will return 4 because today is Wednesday and the date is Nov. 28th. Provided you use the function as WEEKDAY([YourDateColumn]) it will return the matching weekday number for the date value in your column. As you want to textify this number as the name of the weekday, you should construct an IFS expression with the WEEKDAY function as proposed above either in the initial value or in the AppFormula. Hope I’m clear enough.

(Aaron Moolb) #11

@Levent_KULACOGLU OMG. I get it now. Even though today is the 27th it’s really the third week day which would return Tuesday. You were perfectly clear, I was a moron! Thank you so much for being patient and re-clarifying with me

(Fernando López) #12

@Aaron_Moolb read again this: WEEKDAY()