Hi,
Happy New Year
On my attached attendance tracker there is a report sheet called 'All Employees' which is designed to display how many days someone has taken per month, based on a selection from the attendance parameters drop-down menu.
The basic concept of this page works, e.g employees' names list correctly and i can select the appropriate attendance parameter and get a result.
However the issue occurs when some has a "attendance date" that is either the last day of the month or includes the last day of a month. (leave tracker sheet is used to record any leave)
this renders my expected result to return nothing and leaves the monthly count unaffected.
on the leave tracker there is wto employees both called Adam opn the leaver tracker with examples of leave that have the issue.
1 is for the last day 31/01/2018 and the other is 29/05/2018 to 01/06/2018
on the all employee reports page i should see the following
Adam B should have a count of 1 in the Jan cell
Adam P should have a count of 3 for May and 1 for Jun
Selecting different attendance parameters doesn't affect the outcome, which leads me to believe my SUMIFS formula needs changing from a DATE to an EOMONTH but i can't get my head round how it should look for some reason
If anyone can help or shed some light it would be great
Thanks
Mark
Bookmarks