Forum Discussion
IFERROR & Vlookup for attendance tracker
I have created an attendance tracker that needs to show a monthly summary of days taken and then another worksheet needs to count occurrences.
In this workbook, on Monthly Summary - the employee name starts in Column B (B3) and goes to 100. Starting in C3-CAG I have the dates listed for that month. The formula in B4 is currently: =IFERROR(VLOOKUP($B5&C$3,'Absence Log'!$A:$F,6,0),"")
I want to know if instead of entering each date away, I can do the range - so on the absence log, the "start date" is in Column D and end date is in Column E and the output of type of leave is in Column F
I am looking for a way to do a forumla that will look at the start and end dates on absence log worksheet and plot on the monthly summary worksheet all the business days there were within that range.
I still don't understand what exactly is intended, but here's a small attempt, even if I'm almost certain that this cannot be the desired result 🙂.
Otherwise, please always include a file (if it's not possible in the forum, then via OneDrive or somewhere else you can share a file) and explain your plan step by step.
Additional information such as Excel version, storage medium, operating system, etc. would be beneficial for you.
