Apr 16, 2020 02:28 AM|Yang Shen|LINK
on which date employee was present and on which date the employee was absent and on which days there was week off.
This is what i was doing and the custom function i provided should achieve this. Have you tried the solution i suggested?
In this custom function, it accepts three parameters: employee id, start date and end date which define the date range you want to query. And it returns this employee's absent status in this date range.
Or if the solution is not what you want, please tell which part it needs to be updated.