Forum Discussion
Employee attendance tracker
Hi, This is the first time to use "Employee attendance tracker" https://templates.office.com/en-us/employee-attendance-record-tm02780235 I want to change the format of the weekday to start from "F...
MOIA_2020 Have seen this one before. It's full with tricks and hidden "treasures". Personally, I find it quite useless. But to address your problem, the headers are NOT the same. They have added a space for every repeated day. So, the first Sunday it's "SUN" the next one is "SUN " and the next "SUN " etc. And the formulae that checks the day of the week only use the first three characters.
What you need to do is just fill the row as you did and do Find&Replace. Find 2 and replace it by a space, find 3 and replace it by two spaces etc.
Great! That's a good idea. Thanks a lot.