Forum Discussion
Character for Weekday unique
Hi How can I change Weekday to following structure Regards H.
HI Anonymous,
You can use switch function with weekday to replace display characters.SWITCH(WEEKDAY([Date],2),1,"M",2,"Ti",3,"O",4,"T",5,"F",6,"L",7,"S","")
Sample calendar:
Calendar = ADDCOLUMNS(CALENDAR("1/1/2018","12/31/2018"),"WeekNum",WEEKNUM([Date],2),"WeekDay",SWITCH(WEEKDAY([Date],2),1,"M",2,"Ti",3,"O",4,"T",5,"F",6,"L",7,"S",""))Regards,
Xiaoxin Sheng
HI Anonymous,
You can use switch function with weekday to replace display characters.
SWITCH(WEEKDAY([Date],2),1,"M",2,"Ti",3,"O",4,"T",5,"F",6,"L",7,"S","")
Sample calendar:
Calendar = ADDCOLUMNS(CALENDAR("1/1/2018","12/31/2018"),"WeekNum",WEEKNUM([Date],2),"WeekDay",SWITCH(WEEKDAY([Date],2),1,"M",2,"Ti",3,"O",4,"T",5,"F",6,"L",7,"S",""))
Regards,
Xiaoxin Sheng