Forum Discussion
Specific Days of the week
Hello, I am trying to find how I can formula my data to show only specific days of the week (T, W, Th, F, S). I don't want to include Sunday and Monday as those days are zeroes and it throws off my l...
=CHOOSE(IF(MOD(ROW(B1),5)=0,5,MOD(ROW(B1),5)),"T","W","Th","F","S")You can try this formula as shown in the screenshot.