Hi everybody
I'm working on an attendance sheet but I'm calculating the absence days by blank cells but the weekend is Sunday not for all
I need to count if an employee checked in or out any 6 days pass the 7th day ( cells in red ) but if he checked in or out 5 days leave the 6th day as weekend and the 7th day as absent (cell in green)
Bookmarks