Hello All,
I am looking for a formula that will display the 5-day work week in 5 cells but rotate the day that has past back to the end. So if today is Monday, the first cell would display it as Monday; when it because Tuesday, then everything would just shift, and not Tuesday would be in the first cell, and Monday would be in the last.
I am also only looking to only display these characters. Is this at all possible
I am looking for a formula that will display the 5-day work week in 5 cells but rotate the day that has past back to the end. So if today is Monday, the first cell would display it as Monday; when it because Tuesday, then everything would just shift, and not Tuesday would be in the first cell, and Monday would be in the last.
M | T | W | TH | F |
I am also only looking to only display these characters. Is this at all possible