Hello all,
I am trying to make a timekeeping file for my wife's job and i am so stuck
Attached you can find an example.
The ideea is that, in my country, if i am working on saturday i must be free next monday. I tried to automatize a little bit the table, since there are around 200 people on it and she must make it every month...
So, right now i must combine the formula on M9 with another formula that should look if the last saturday (in this case K9) contains a "/" (free) or an "8" (was working 8 hours). If last saturday contains "/" than M9 should contain an "8", if last saturday contains "8", than M9 should contain an "R" (from recovery).
I am sure that this can be done much easier than i did, that's why i am asking for help.
Thank you in advance
Bookmarks