Try this for a date in A1
A2: ="Week"&IF(WEEKDAY(A1,2)>5,"end","day")
Is that something you can work with?