Hi All,
Please help!
I need a formula to identify any 6th and 7th working days out of 7 working days for F column. So if an employee works on 6th and 7th day need to pay overtime in P column.
However, if skipping one day on 7 working days, the next working day will be counted minus 1. Sorry if it is confusion, below is an example if an employee does not work on that 4th day, it would not be counted. 7th working day will be come day 6 to be paid overtime.
Please help!
I need a formula to identify any 6th and 7th working days out of 7 working days for F column. So if an employee works on 6th and 7th day need to pay overtime in P column.
However, if skipping one day on 7 working days, the next working day will be counted minus 1. Sorry if it is confusion, below is an example if an employee does not work on that 4th day, it would not be counted. 7th working day will be come day 6 to be paid overtime.