Timekeeping file in Excel

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

Thank you for your answer etaf,
Your solution simplify the formula, a lot.

Both of them are working great, even the second one:
=IF(WEEKDAY(I$8;2) < 6; 8; "/")

Considering the fact that she will do this every month and the time is limited, i tried to simplify everything as much as possible. For example, if she will change the month in E2, everything will change, including weekends.

Sorry for not being too clear in explaining what exactly am i looking for

I attached another file that should explain better:
- we are only allowed to work two weekends every month, so if i am working in 05.01 (J9 = Saturday) i must recover this day on next Monday (L9 = "R"). So when i manually add "8" to J9, the following Monday (L9) should turn from "8" to "R".
- Then automatically, next Saturday should be free (Q9)and that means that S9 should be a normal working day
- then the third Saturday (Y9) will be a working day again, resulting that the third Monday of the month (AA9) will be free again ("R")

So all days will be auto complete with 8, except saturdays and sundays.
When i manually enter 8 on J9, L9 should transform from 8 to "R", nothing should be changed on next weekend (Q9 & R9), and then Y9 should be again 8 and AA9 should be again "R"

I hope i made myself understood )
It's so easy in my head

Thanx again.

Edit: regarding holiday/training / sickness, they will be added manually...

Thank you so much etaf.
Everything is working as it should.

Best regards!