Hello everybody,
I'm raising this topic because i need your help in order to solve a problem which i have on the following excel function:
=IF(ISNA(MATCH($A6&D$4;Info!$P:$P;0));IFNA(INDEX(MarkLeave!$G:$G;MATCH(MonthlySummary!$B6&MonthlySummary!D$4;MarkLeave!$A:$A;0));"");"BH")
I will go more in details in order to explain you what i would like to do and what i did:
I'm trying to build a vacation planner. Basically i have 3x sheets:
- "MonthlySummary" (which is a table with dates, people, type of permission requests, summary of everything)
- "MarkLeave" (which is the page where people can request the permission, i built it in combination of VBA)
- "Info" (where i have a list of people, abbreviation of permissions, available and annual amount of vacation days, bank holidays)
The sense of this vacation planner is to request the permission on "MarkLeave" and taking in consideration the type, put the icon in the table visible on "MonthlySummary" .
Everything is working, but i'm having difficulties right from the moment i started to implement Start/End Dates !!
Previously, this vacation planner was only working with standard dates (one by one) but i retained necessary also to implement something for take more consecutives days together.
I also have a kind of solution, but honestly i'm finding difficulties to implement it on the formula i wrote before.
=AND(calendarday>=startdate,calendarday<=enddate
I wrote names in the formula just for let you understand better:
calendarday = is the day of the month which you can watch at attached screenshot "ex1" (from D4 to AH4)
startdate = is visible at attached screenshot "ex2" (column D)
enddate = is visible at attached screenshot "ex2" (column E)
Just as information, ID (visible on ex2) is basically Emp ID + Start Date
I would like that days between Start Date and End Date can be populated with Abbreviation name on "MonthlySummary" table.
I already did everything, but it is gonna work only with Start Date (as mentioned before, initially i built this project only for a single date) .
Are you able to support me?
Thanks in advance
Edit:
For privacy reasons, i maskered names, locations and ID
Bookmarks