Employee attendance tracker

%3CLINGO-SUB%20id%3D%22lingo-sub-1453454%22%20slang%3D%22en-US%22%3EEmployee%20attendance%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453454%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThis%20is%20the%20first%20time%20to%20use%20%3CSTRONG%3E%22Employee%20attendance%20tracker%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Femployee-attendance-record-tm02780235%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2Fen-us%2Femployee-attendance-record-tm02780235%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20want%20to%20change%20the%20format%20of%20the%20weekday%20to%20start%20from%20%3CEM%3E%22Friday%22%3A%22Thursday%22%3C%2FEM%3E%20instead%20of%20%3CEM%3E%22Sunday%22%3A%22Saturday%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CI%3ENote%3C%2FI%3E%3C%2FSTRONG%3E%3CEM%3E%3CSTRONG%3E%3A%3C%2FSTRONG%3E%20I%20tried%20to%20rename%20the%20weekdays%20but%20it%20considers%20them%20as%20repeated%26nbsp%3Bso%20it%20adds%202%20to%20the%20new%20name%2C%20i.e.%20If%20i%20renamed%20%22SUN%22%20to%20%22FRI%22%20the%20next%20Friday%20will%20be%20renamed%20%22FRI2%22%20and%20then%20%22FRI3%22%20and%20so%20on%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Screenshot_1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197869i4B37F908EEF6CD71%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot_1.png%22%20alt%3D%22Screenshot_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1453454%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1453547%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20attendance%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695007%22%20target%3D%22_blank%22%3E%40MOIA_2020%3C%2FA%3E%26nbsp%3BHave%20seen%20this%20one%20before.%20It's%20full%20with%20tricks%20and%20hidden%20%22treasures%22.%20Personally%2C%20I%20find%20it%20quite%20useless.%20But%20to%20address%20your%20problem%2C%20the%20headers%20are%20NOT%20the%20same.%20They%20have%20added%20a%20space%20for%20every%20repeated%20day.%20So%2C%20the%20first%20Sunday%20it's%20%22SUN%22%20the%20next%20one%20is%20%22SUN%20%22%20and%20the%20next%20%22SUN%20%26nbsp%3B%22%20etc.%20And%20the%20formulae%20that%20checks%20the%20day%20of%20the%20week%20only%20use%20the%20first%20three%20characters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20need%20to%20do%20is%20just%20fill%20the%20row%20as%20you%20did%20and%20do%20Find%26amp%3BReplace.%20Find%202%20and%20replace%20it%20by%20a%20space%2C%20find%203%20and%20replace%20it%20by%20two%20spaces%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1453832%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20attendance%20tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453832%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat!%20That's%20a%20good%20idea.%20Thanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 "Friday":"Thursday" instead of "Sunday":"Saturday"

 

Note: I tried to rename the weekdays but it considers them as repeated so it adds 2 to the new name, i.e. If i renamed "SUN" to "FRI" the next Friday will be renamed "FRI2" and then "FRI3" and so on

 

Screenshot_1.png

 

2 Replies
Highlighted

@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.

Highlighted

@Riny_van_Eekelen 

Great! That's a good idea. Thanks a lot.